Hi,
I am trying to convert a date in yearmonth format to regular date . The day will be always first of the month
that is input is 201809(text) output is 01/09/2018(date )
load( local!FDYMYear: left( ri!yearmonth, 4 ) , local!FDYMMonth: if( len( ri!yearmonth ) = 5, right( ri!yearmonth, 1 ), right( ri!yearmonth, 2 ) ), todate(local!FDYMMonth&"/"&"01"&"/"&local!FDYMYear) )
i am using the above rule . it works fine for all the dates except if the month is October .
it is not working for 201810 ,201710 . it works for all the other yearmonths
Discussion posts and replies are publicly visible
Its a number right, try this
=load(
local!month: fn!mod(ri!yearMonth, 100),
local!year: fn!tointeger(ri!yearMonth / 100),
{
local!month,
local!year
}
)