A
Angus
Hi,
I am trying to get a European date format in a forms text
box. This text box will be data entered by a user of the
database and stored for when the record is viewed in
future. My regional settings are set to Australia and I
have set the format to "short date" but this doesn't work.
In the text box properties I have tried to enter under
formats dd\/mm\/yyyy and dd/mm/yyyy neither of these hold
the "data entered" date in the same "screen" date format.
When I enter the date "21/09/04" or "21/09/2004" the
date "04/09/2021" appears.
I have been directed to the site
http://members.iinet.net.au/~allenbrowne/ser-36.html but
this did not appear to offer me any help
Any help would be appreciated.
Thanks,
Angus
I am trying to get a European date format in a forms text
box. This text box will be data entered by a user of the
database and stored for when the record is viewed in
future. My regional settings are set to Australia and I
have set the format to "short date" but this doesn't work.
In the text box properties I have tried to enter under
formats dd\/mm\/yyyy and dd/mm/yyyy neither of these hold
the "data entered" date in the same "screen" date format.
When I enter the date "21/09/04" or "21/09/2004" the
date "04/09/2021" appears.
I have been directed to the site
http://members.iinet.net.au/~allenbrowne/ser-36.html but
this did not appear to offer me any help
Any help would be appreciated.
Thanks,
Angus