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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|