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!

=Date()

Should use your regional setting

Jon

"Shugwan" <(E-Mail Removed)> wrote in message
news:C07ACAC6-6139-4667-B839-(E-Mail Removed)...
>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!

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

"Jon Lewis" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =Date()
>
> Should use your regional setting
>
> Jon
>
> "Shugwan" <(E-Mail Removed)> wrote in message
> news:C07ACAC6-6139-4667-B839-(E-Mail Removed)...
>>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!
>
>

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" <(E-Mail Removed)> wrote in message
> news:C07ACAC6-6139-4667-B839-(E-Mail Removed)...
> >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!
>
>
> .
>

Shugwan

You didn't notice:

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

Jon


"Shugwan" <(E-Mail Removed)> wrote in message
news:847D4B49-BE50-4D79-A317-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:C07ACAC6-6139-4667-B839-(E-Mail Removed)...
>> >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!
>>
>>
>> .
>>

Hi Jon,

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

Doug

"Jon Lewis" wrote:

> Shugwan
>
> You didn't notice:
>
> =Date() as opposed to =Date$()
>
> Jon
>
>
> "Shugwan" <(E-Mail Removed)> wrote in message
> news:847D4B49-BE50-4D79-A317-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:C07ACAC6-6139-4667-B839-(E-Mail Removed)...
> >> >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!
> >>
> >>
> >> .
> >>
>
>
> .
>