Toad World® Forums

Date Name format in Toad Reports


#1

Hello again - When I put a date field on my TDA Report and click the little white check in the upper right corner, the formatting there doesn’t appear to have a Date Name format. Is it somewhere else or ??

Thanks,

Tom


#2

You are in the right area. See screenshot for Date Format strings.

Debbie
DateString.png


#3

Sorry Debbie, I should have been clearer. What I’m looking for is the ability to take a date field and pull out the month name. So, instead of 01/15/2010, is there a formula or format that would just show “January”?

Thanks,
Tom


#4

Try the custom tab. See screenshot.

Debbie

P.S. Of course you can do this in SQL too.
MOnth.png