Problem with date format

[manoj9849967222]

Hi All

I have a problem with date format. I have designed a table with one of the field as Date. when i enter the date it is comming in mm/dd/yyyy format. Is there a way to change the format to dd/mm/yy format.

Please help


Regards
Manoj

[lee123]

yes you can do this in the properties in the format

enter:

dd/mm/yy

[manoj9849967222]

Hi Lee123


Thanks for your reply. This is working but again when i go to table the dates are again converted to mm/dd/yyyy format.

Regards
Manoj

[Jim Doherty]

Hi Lee123


Thanks for your reply. This is working but again when i go to table the dates are again converted to mm/dd/yyyy format.

Regards
Manoj

Go into the table in design and do the same there as Lee123 suggested

[manoj9849967222]

Thanks

I really appreciate you all. Really doing a Great Job.

Thanks Again

Regards

Manoj

[lee123]

glade it works now. and glade i could help.

and thanks Jim, for putting (design View in there i forgot to add that)

lee123