Month (mmm) to Month(m)

Hi Sunil

use the date function ""month.

month( local!month_selected)

 

local!month_Selected: "AUG",
month(local!month_Selected)

- This will not work Gaurav and throws the below error.

Expression evaluation error: Invalid variable(s) found: 'AUG'.

Not sure if there is an inbuild function to achieve this but the following is one of the ways to do it.

load(
local!a:{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},
local!b:{1,2,3,4,5,6,7,8,9,10,11,12},
displayvalue(ri!input,local!a,local!b,null())
)

Hi Sunil Mohan,

There is no inbuilt function for your scenario as I know.

One solution is we can use display value function to achieve this as mentioned below. Check if this approach works for your case.

Hi Sunil,

You can try using below method.
load(
local!a: CONS!MONTHS
local!b: CONS!MONTH_VALUE
displayvalue(local!month_selected,,local!a,local!b,null())
)


where CONS!MONTHS will have valure as {"JAN", "FEB"....."DEC"}
and CONS!MONTH_VALUE will have {1,2,3...12}

Let me know if this works out for you

Hi Sunil,  your problem can be solved with exactly below code.

load(
local!date: "01-" & ri!mon & "-" & year(
today()
),
{
month(todate( local!date),{})
}
)

Thanks.

It would be better if you create your own rule for the purpose.
Try this code...

wherecontains(ri!input,{"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"})

here ri!input has to be of type text and it should have proper input like JAN, FEB,MAR...

Hope this will be helpful!

Many way to achieve this. I felt, Amit's code will work perfect for run-time input by user (dynamically) with simple logic . Additionally, you can validate user's value (i.e. ri!mon) which should be valid mmm (Jan,Feb to Dec only).

Thanks Amit, it help me

You can use datetext(todate(local!date),"M") also.