topic Re: Converting Text to Dates in QlikView

Converting Text to Dates

Tue, 18 Jun 2013 19:47:25 GMT

I have a list of text.

Ex.

Month 1

Month 2

Month 3

Month 4 etc...

Where month 1 is the current month, month 2 is the previous month, month 3 is the month before that and so on.

I need to convert them so that the current month returns the first day of this month (6/1/2013, the previous month, the month before that, etc all as the first day of their corresponding months).

Month 1 06/01/2013

Month 2 05/01/2013

Month 3 04/01/2013

Month 4 03/01/2013

Any ideas would be fantastic as I am completely stuck.

Thanks!

Re: Converting Text to Dates

swuehl — Tue, 18 Jun 2013 20:19:12 GMT

Try something like

LOAD Month,

Date(Monthstart(today(),1-subfield(Month,' ',2))) as MonthDate;

LOAD * INLINE [

Month

Month 1

Month 2

Month 3

Month 4

];

Re: Converting Text to Dates

Tue, 18 Jun 2013 20:33:01 GMT

AWESOME!!