Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
=Month(Date(Date#([SPEND MONTH], 'YYYYMM MMM')))
Assuming that your field value is '201402 Feb', you will get Feb here.
What are you showing in your screenshot example in the OP? Is it a listbox?
How about:
=right([SPEND MONTH], 3)
Hi,
As your field contains data like "201401, 201402,..."
You can try in the script:
Table:
LOAD
[SPEND MONTH],
Month(Date#('01/'&right([SPEND MONTH],2)&'/'&left([SPEND MONTH],4),'DD/MM/YYYY')) as SpendMonth
FROM
File;
Then your field SpendMonth will contain the month name
Can you post sample app
Hi Charen - probably a silly suggestion, so ignore if not applicable: it almost sounds like you're looking for the right(datestring,2) (e.g. '201403' to yield 03), and then to applymap the numbers to a loaded mapping table, e.g. with 03,Mar or something to get the 'monthname' (?)