I want to convert a numeric date to text?

[Guest]

I have a date field that stores the data as "MMDDYY"... I would like to
convert the month portion of the field to text... (Ex: from 020505 to
"FEBRUARY"...

Any help would be greatly appreciated...!!!

 

[Rick B]

Dates are not stored in any date-looking format. They are stored as a
number representing the date. You can DISPLAY them in any of several
formats in your forms, queries, or reports.

Look at the FORMAT option in help for more information.

for example, =Format([somedatefield], "long date")

or = Format([somedatefield],"mmdd")


etc.




Rick B

 

[fredg]

I have a date field that stores the data as "MMDDYY"... I would like to
convert the month portion of the field to text... (Ex: from 020505 to
"FEBRUARY"...

Any help would be greatly appreciated...!!!

If this is a Date datatype field, simply set the Format Property of
the control on the form or report to:
mmmm