V4RB and dates

[Fred.Stephenson]

I had the same problem on Friday and gave it a miss for the weekend.
I just found the problem, at least for me

cursor.field("date").setstring(d.shortdate) is the culprit

cursor.datefield("date").set(d.year,d.month,d.day) is the solution

looks like setstring is broken.

Is this what you were doing Cindy??

all the best

Fred



>on 2/8/04 2:09 AM, Cindy Brown at cindy at kowhaiprogramming.com wrote:
>
>Hi Cindy,
>
>>  I have recently set up a new database with about three date fields. I am
>>  running OS X and my system date formats are set to Australian (d/m/y) as I
>>  live in New Zealand. In a previous program I had written, dates are stored
>>  and retrieved with no problems. In the new database, when I save a date
>>  higher than the 15th, Valentina stores the date 16 days previously. For
>>  example, if I put a date in as 17/12/03, the date is stored as 1/12/03. I
>>  know it is only happening when it is saved as when I bring up a message box
>>  just after I set the datestring showing what is in the text box and what is
>>  in the saved field, they are both different.
>>
>>  Vtransactions.field("Date").SetString (datefield.text)
>>  MsgBox datefield.txt + "   " + vtransactions.field("Date").GetString
>>
>>  This should bring up the same thing but is not when the date is higher than
>>  the 15th.
>>
>>  Is there any reason for this and any way I can stop it from happening?
>
>Please check
>
>     db.DateFormat
>
>Property. May be you have wrong value?
>
>--
>Best regards,
>Ruslan Zasukhin      [ I feel the need...the need for speed ]
>-------------------------------------------------------------
>e-mail: ruslan at paradigmasoft.com
>web: http://www.paradigmasoft.com
>
>To subscribe to the Valentina mail list go to:
>http://lists.macserve.net/mailman/listinfo/valentina
>-------------------------------------------------------------
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina