How do I change the FORMAT of a date in Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to change the actual format of a date in Access 2003 from mm/dd/yy to
yyy/mm/dd, not just the appearance of the date.

Got any suggetsions?
 
I need to change the actual format of a date in Access 2003 from mm/dd/yy to
yyy/mm/dd, not just the appearance of the date.

Got any suggetsions?
Click to expand...

I don't quite understand your question since both mm/dd/yy and
yyy/mm/dd are date formats (which is just the appearance of the date,
not how it is stored).

Today is actually stored, in Access, as 38887.
 
Seeing as how format is appearance I assume you want the date to be text.

Format([YourDateField],"yyyy") & "/" & Format([YourDateField],"mm") & "/" &
Format([YourDateField],"dd")

And I am also assuming you meant "yyyy" instead of "yyy". If you realy ment
"yyy" then it would be like ---
Right(Format([YourDateField],"yyyy"),3) & "/" & Format([YourDateField],"mm")
& "/" & Format([YourDateField],"dd")
 
RheaS said:
I need to change the actual format of a date in Access 2003 from
mm/dd/yy to yyy/mm/dd, not just the appearance of the date.

Got any suggetsions?
Click to expand...

Format is a display function, not a storage function. Access stores
dates as a simple number with no formatting.
 
RheaS said:
I need to change the actual format of a date in Access 2003 from
mm/dd/yy to yyy/mm/dd, not just the appearance of the date.

Got any suggetsions?
Click to expand...

Format is a display function, not a storage function. Access stores
dates as a simple number with no formatting.
 
Back
Top