Date Name format in Toad Reports

Toad Data Point
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
DateString.png878×629 57.3 KB

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