How can i make the dates be displayed all in one format, like 'dd/mm/yy' just like access assigns it when you create the date field and in it's format type as short format ?? rathern then to be displayed in mm/dd/yy format after you insert it into a query then re-display it again...
please download and review my short example databse below
I used to have date display problems. I have changed all formats to yyyy/mm/dd, and if it is not formatted as such, I will use the Format command to make it appear like this. This way no one is confused by this international standard as to which is the year, which is the day and which is the month.
if I assign a variable x the format command, then place x in my insert query in the 'insert' button code, will the dates be displayed as yyyy/mm/dd format??
If you noticed, the date format in the firstdate field is as dd/mm/yy, but in the Due Date field in the subform it is displayed as mm/dd/yy, i am trying to make it in the DueDate field to be displayed as dd/mm/yy!! Hence, If you noticed that if htere is a date with the 13th day example
firstdate field has 13/11/03 (dd/mm/yy) but in the subform
Due Date field displays 03/11/13 (yy/mm/yy) where I have no clue why it does that after every 12th day of a month?? I thought it may had to do with the
INSERT INTO tblPayDates('" & me.clientID.value & "', #" & dd & "#)
query?? It's weird!!
To change how a date is displayed in a table, you must use the Format property.
To change how a date is displayed on a form, you must use the Format property.
To change how a date is displayed in a report, you must use the Format property.
If you do not specify the format property, then you will be at the mercy of the Regional Settings. The problem with mm/dd/yy or dd/mm/yy is that the computer sometimes misinterprets it. if you always use the yyyy/mm/dd format, the computer has not yet misinterpreted it on me.