A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Default Value =Date$() in UK Date Format



 
 
Thread Tools Display Modes
  #1  
Old May 11th, 2010, 09:50 AM posted to microsoft.public.access.forms
Shugwan
external usenet poster
 
Posts: 3
Default Default Value =Date$() in UK Date Format

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!
  #2  
Old May 11th, 2010, 11:29 AM posted to microsoft.public.access.forms
Jon Lewis[_3_]
external usenet poster
 
Posts: 40
Default Default Value =Date$() in UK Date Format

=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!



  #3  
Old May 11th, 2010, 12:09 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Default Value =Date$() in UK Date Format

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





  #4  
Old May 11th, 2010, 12:27 PM posted to microsoft.public.access.forms
Shugwan
external usenet poster
 
Posts: 3
Default Default Value =Date$() in UK Date Format

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!



.

  #5  
Old May 11th, 2010, 12:55 PM posted to microsoft.public.access.forms
Jon Lewis[_3_]
external usenet poster
 
Posts: 40
Default Default Value =Date$() in UK Date Format

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!



.



  #6  
Old May 11th, 2010, 02:52 PM posted to microsoft.public.access.forms
Shugwan
external usenet poster
 
Posts: 3
Default Default Value =Date$() in UK Date Format

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" 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!


.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.