Default Value =Date$() in UK Date Format

S

Shugwan

I have a form with a date field and want to populate it with the current date
using the =Date$() in the default value field. Unfortunately this uses the US
date format (mmddyy) and I need it to be in the UK format (ddmmyy). Regional
settings are set to UK on the PC.

Can anyone please advise me how to acheive this as I can't find any
reference to it anywhere on the web!
 
J

Jeanette Cunningham

I have a similar with a client's notebook computer.
In this case we want it to be Australian dd/mm/yyyy format, but it stays in
American format.
Other programs on this computer have the same problem with dates.
My IT person says he can fix it. I am trying to talk client into getting it
fixed, but she thinks it is OK, the staff will just have to get used to
american dates.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
S

Shugwan

As stated above the regional settings on the PC are set to UK format, that's
the strange thing.
 
S

Shugwan

Hi Jon,

You're right, I didn't notice that and it did resolve the issue - many thanks!

Doug
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top