month in num to string

[arulsettu]

Hi,

i am having month filed like this

month

0

1

2

3

4

5

6

7

8

9

10

11

12

i want to convert this in jan,feb,mar......

so used this Month(MakeDate('2014',monthfield)) as newmonth

its working i used this newmonth field to convert quarter but it is not deriving the quarter. also i used this newmonth filed in chart its not giving the result. if i use old month field its giving desired result

any suggestions plz?

[arulsettu]

when i use that converted month the result in chart is gone

can any one suggest why?

thanks

[buzzy996]

tested,this one is working...,try this...

=Date(MakeDate(year(today()),month,Day(today())),'MMM')

[arulsettu]

please check this one in chart

[buzzy996]

tht expression written in chart object and tested,it's working.

are u tried? getting any issue?

[arulsettu]

the expression giving current date. check the sample app

[buzzy996]

pfa,sheet4 & main4 script

[arulsettu]

Hi Siva,

          month is not a issue i converted my month into string. issue is converted month is not working in set analysis

plz check above app test(1)(2)

thanks

[tresesco]

Yours doesn't work, because you have created month using date(), that means it holds equivalent date values at the backend.

Instead of,

Date(date#(TBAL_CAL_MONTH,'MM'),'MMM') as TBAL_Month

try like:

Month(date#(TBAL_CAL_MONTH,'MM')) as TBAL_Month

[arulsettu]

Hi tresesco

                        its showing the month field in string. but when try to get quarter from this filed its showing only

Q1 and Q4.  and the main issue is i want to show last six month values from TBAL_Month. they all are showing zero

plz suggest something

thanks

[buzzy996]

can u try to replace this in ur script and try,

Date(MakeDate(year(today()),TBAL_CAL_MONTH,Day(today())),'MMM') as TBAL_Month