Prev: Delete record button not working (allowedits = true)?
Next: Dlookup Question
From: Shugwan on 11 May 2010 04:50
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!
From: Jon Lewis on 11 May 2010 06:29
=Date()

Should use your regional setting

Jon

"Shugwan" <Shugwan(a)discussions.microsoft.com> wrote in message
news:C07ACAC6-6139-4667-B839-89D386B05EA0(a)microsoft.com...
>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!


From: Jeanette Cunningham on 11 May 2010 07:09
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" <jon.lewis(a)cutthespambtinternet.com> wrote in message
news:uJNbqTP8KHA.1436(a)TK2MSFTNGP06.phx.gbl...
> =Date()
>
> Should use your regional setting
>
> Jon
>
> "Shugwan" <Shugwan(a)discussions.microsoft.com> wrote in message
> news:C07ACAC6-6139-4667-B839-89D386B05EA0(a)microsoft.com...
>>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!
>
>


From: Shugwan on 11 May 2010 07:27
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" <Shugwan(a)discussions.microsoft.com> wrote in message
> news:C07ACAC6-6139-4667-B839-89D386B05EA0(a)microsoft.com...
> >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!
>
>
> .
>
From: Jon Lewis on 11 May 2010 07:55
Shugwan

You didn't notice:

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

Jon


"Shugwan" <Shugwan(a)discussions.microsoft.com> wrote in message
news:847D4B49-BE50-4D79-A317-448155662B41(a)microsoft.com...
> 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" <Shugwan(a)discussions.microsoft.com> wrote in message
>> news:C07ACAC6-6139-4667-B839-89D386B05EA0(a)microsoft.com...
>> >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!
>>
>>
>> .
>>


 |  Next  |  Last
Pages: 1 2
Prev: Delete record button not working (allowedits = true)?
Next: Dlookup Question