topic Re: date function informations in QlikView

date function informations

Wed, 23 May 2012 14:53:24 GMT

hi,

I' ve a little question about the date function, the problem is the following:

I need a function to do this:

2012001 must become= 1/1/2012

2012002 must become= 2/1/2012

....

2012032 must become= 1/2/2012

...

thank you very much

jonathandienst — Wed, 23 May 2012 15:01:43 GMT

Assuming you want this in script (let's call your input dates InputDate):

...

Date(MakeDate(Left(InputDate, 4), 1, 1) + Mid(InputDate, 5, 9)) As OutputDate,

...

You can use the same logic in an expression, but this sort of transform should be done in script)

Hope that helps

Jonathan