Date Format 1

[Silvinho]

I have some pages that enter information into an Access database using the Ultradev Insert Record feature.

Some of the fields are Dates.

The problem i have is the Date format always changes from British DMY format to US MDY.

ie: the date 08/01/02 (8th of january) alwys comes up in the database as 01/08/02 ( 1st of August )

I have heard of Set Date Format dmy but i don't know how to use this within Ultadev's features.

Can anyone help?

 

[schase]

I have not used or tried to play around with a brittish version, but have you tried formatting the date within the field in access?

Open the affected table in Access, switch to design view,
click the date field

Down below you will see format or general properties
long date, short date, etc. Select the one you want.

 

[Cheech]

I format the date myself so that I can decide what it looks like
strDate = Date()
Datearray = split(strDate, "/", -1)
dd = Datearray(0)
mm = Datearray(1)
yy = Datearray(2)
strNewDate = (dd + "/" + mm + "/" + yy)

you can then upload it to your server and if the format is wrong just change the array value to reflect the correct format Live long and make your kids suffer..