Discussion Board for collaboration related to QlikView App Development.
I've a number of dates that I want to look like
The date right now looks like e.g. 15/12/2015 (European format).
I would like it to look like above so I've gotten so far.
will give me 122015
now I want to get it to look like 201512
I could get both values but how do I reverse concatenate?
right(right(purgechar(Calls.Date,'/'),6) ,2) gives me 12
left(right(purgechar(Calls.Date,'/'),6) ,4) gives me 2015
but how do I reverse it so the 2015 comes out first and then the 12???
Thanks in advance.
Hi Try Like this:
LOAD *,Date(Date#(DATE_VALUE, 'DD/MM/YYYY'), 'YYYYMM')as DATE_VALUE_Target INLINE