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?

On Mon, 19 Jun 2006 14:32:02 -0700, RheaS wrote:

> 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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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" wrote:

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

RheaS wrote:
> 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

Dia duit

RheaS wrote:
> 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

Dia duit