Shugwan

You didn't notice:

=Date() as opposed to =Date$()

Jon


"Shugwan" wrote in message
...
As stated above the regional settings on the PC are set to UK format,
that's
the strange thing.

"Jon Lewis" wrote:

=Date()

Should use your regional setting

Jon

"Shugwan" wrote in message
...
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!


.