Formating a date

[kentwoodjean]

Quick question. I have checked on help pages, and unable to format corrrectly. The dates on my table are currently formated as numbers in a column with data to the right of it 1/1/03
2/1/03
3/1/03

I want my data displayed as: Jan
Feb
Mar

 

[Steve101]

You might need to elaborate on your problem here. I cannot understand it. At any rate, if you have a date, and you want to extract the month in mmm format, then try using the Format function; eg.

Yourmmm = format(YourDateField, "mmm&quot

will return Jan, Feb, Mar ... by extracting the month from the date field, and abbreviating it to 3 characters.

Hope this helps,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[davidrfloyd]

I was having the same problem, and figured out the solution while looking for an answer here at Tek-tips. My error was when I created the table, I set the date field Data Type as "Text." Changed the Data Type to Date/Time and the format code works fine. In the properties of the Date field on my report, I just inserted "mmm" (without the quotes) into the Format field and it works. Instead of "11/1/2002", I get "Nov".

Hope this is helpful.