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

[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?

 

[fredg]

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 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.

 

[Guest]

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

 

[Joseph Meehan]

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?

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

 

[Joseph Meehan]

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?

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