Date format to a literal

[retiring]

I am working on a scheduling application. The form for data input uses a general date format for dates an employee is unavailable for scheduling. I would like to create a report that accumulates employee unavailable hours by year, month, and date. I would like to produce a literal for the month and a number for the day of the month. From an input of 01/09/02 to produce:

Employee Name
2002 (system year is good enough for this)

January 9
etc.

I do not know a simple way to do this and would appreciate any suggestions.

Thanks.

 

[JPeters]

Lookup the Date() and Date$ functions in your help file. See if you can't format them to appear in the full text format. I seldom do this, but if not you could always use the Day, Year, and Month functions... they return integers .. Ie: 1-12 for months.. Then just run some code that says If Month = 1 then - Month = "January" ... etc.
There's probably a way to get Date() to format in full text.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------