Prev: Delete record button not working (allowedits = true)?
Next: Dlookup Question
From: Shugwan on 11 May 2010 09:52
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" <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!
> >>
> >>
> >> .
> >>
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Delete record button not working (allowedits = true)?
Next: Dlookup Question