Convert numeric month to text month

johnhung

New member
Local time
Today, 11:51
Joined
Dec 3, 2002
Messages
6
User enters a StartDate on a form (mm/dd/yy). I would like to be able to convert the mm to a month format for output. Example when they enter 01/30/03 I would like a field to hold the value as "Jan".

Thanks.
 
Set the field format to medium date. That way, the user types in 02/09/03 (or even just 2/9/03), but it appears on the form as 02-Sep-03. The field in your table can just be left as short date format, or whatever you want. The same goes for reports. I hope that's what you were after.
 
The format function can do that.

StartDate = 01/31/2003

Format(StartDate,"mmm") = Jan
Format(StartDate,"mmmm") = January

Check Format in the help files for more info and examples.

HTH
 

Users who are viewing this thread

Back
Top Bottom