V4RB and dates

[Cindy Brown]

Hi All,

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?

Thanks in anticipation.

-- 

Cindy Brown
Programmer
SchoolMaster

Kowhai Programming Systems
PO Box 198, Invercargill
81 Marama Avenue South, 9RD Invercargill
Phone (03) 213 1243
Fax (03) 213 1248
Mobile (021) 354 930
<http://www.kowhaiprogramming.com/>