
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Converting numbers to month name
Hi,
Can some one help me in converting the numbers to month names?
I want to remove this number and just want to have the month names.
or is there any possibility to just change these numbers to month names.
Initially i used if statement to bring the month names. But i dont know how to replace the numbers with month names. Thank you.
- « Previous Replies
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
Month(MakeDate(1,MonthNum)) as Month

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Provide sample file or may be you can try MonthName( DateField ) if you have any date field in the data model.
Regards
Anand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Sorry its not working out. Any other suggestions?
Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try this also in load script
Num( Month( Date( DateField,'YYYYMM' ) )) as NumMonth
Or
Num( Month(DateField) ) as NumMonth
Ex:-
=Num( Month( Date( Today(),'YYYYMM' ) ))
Regards
Anand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
This is the actual field
Here i need to change the numbers into months .
Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
Month(MakeDate(1,Mid([SPEND MONTH],5))) as Month

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Num( Month( Date( [SPEND MONTH],'YYYYMM' ) ) ) as NumMonth
Or
Num( Month( [SPEND MONTH] ) ) as NumMonth
Regards
Anand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Month(MakeDate(1,num(right([SPEND MONTH], 2)))) as Month

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I added and update the tresesco expression as
Month(MakeDate(1,Mid([SPEND MONTH],5,2))) as Month
Or
Month(MakeDate(1,right([SPEND DATE], 2))) as Month
Regards
Anand

- « Previous Replies
- Next Replies »