Setting Date Format

[MickeD]

Hi,

We are working with .DBF files
and date format is dd/mm/yyyy.

also we have a VB app that update DB records
If date format on the computer is mm/dd/yyyy and days value <=12 VB revers days and months values ex. 01-Dec-2000 was stored as 12-Jan-2000.

Is there any method to store date in specified format?
(Not FORMAT() function that return string)

Thanks

 

[sandeep02]

set the date format in the regional settings to dd/mm/yyyy

 

[edderic]

Format(Date,&quot;Currency&quot

Eric

Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX

http://www.createsoftware2000.com