Date format reverts back to previous format (1 Viewer)

[Bobp3114]

Customer asks for the dates on the forms to be in Medium format instead of short format.
I have changed to this in the tables used and on each of the forms controls
The tables look as expected
When I change the a date on the form it reverts back to the short format??????
What have i missed?

 

[arnelgp]

add also the Format (Property) of the data textbox in design view.

 

[Gasman]

add also the Format (Property) of the data textbox in design view.

and on each of the forms controls

 

[xavier.batlle]

And also the Mask (Textbox Property) that's used the you enter data in the textbox.

 

[CJ_London]

I think the OP means whilst editing the date by the user typing it in. If that is the case, then also look at applying an input mask - the format property only applies to presentation and hides the actual underlying value

 

[arnelgp]

and on each of the forms controls

is it so hard, considering he is the programmer?

 

[DickyP]

It never helps that Microsoft uses Date format (MDY) that is only used by about 3% of the world's population.

 

[arnelgp]

the OP can "hard" set the format by going to control panel and change the Loale date setting.

 

[DickyP]

the OP can "hard" set the format by going to control panel and change the Loale date setting.

Absolutely agree as with the other stricture about setting the format everywhere used(forms, reports controls etc) but there are still anomalies caused by MS's default - for instance assigning a date to a string to be used in an SQL statement.

Being a Brit I always assign dates to strings as Format(date,"dd/MMM/yyyy") to avoid ambiguities.

 

[arnelgp]

you can also use the ISO 8601 standard date format: YYYY-MM-DD.

 

[BlueSpruce]

It never helps that Microsoft uses Date format (MDY) that is only used by about 3% of the world's population.

SQL date literals are also mm/dd/yyyy. Is it so hard for the world to adapt to the American way when all major software development is done in American English?

 

[arnelgp]

Date format is not an issue.
the problem are those people, not having guidance as to the Basics of
Ms Access.
It is a good advice to Read the Manual first before you try to Operate.

 

[Ken Sheridan]

Being a Brit I always assign dates to strings as Format(date,"dd/MMM/yyyy") to avoid ambiguities.

When I was young one of our officers had been a signaller in the Second World War. I recall him telling us that that was the solution adopted by the British and American forces in signals traffic to avoid misinterpretations of dates. I always use the ISO standard of YYYY-MM-DD for date literals.

 

[DickyP]

SQL date literals are also mm/dd/yyyy. Is it so hard for the world to adapt to the American way when all major software development is done in American English?

Of course we adapt, (hence my usage above) but it is annoying that the other 90+ % of us have to because of American language imperialism.

 

[BlueSpruce]

Of course we adapt, (hence my usage above) but it is annoying that the other 90+ % of us have to because of American language imperialism.

Well someone had to set the standard, like ANSI SQL. Perhaps DMY would've been the standard if IBM, the creator of SQL, and Microsoft were UK companies, or if the UK's ICL would've beat them to the punch, or if the UK would've won the war of 1812.