Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calander

Hi,

How to convert [Mar 2014] as  3/30/2014 and create calander based up on this

out put then calander

Mar 2014---3/30/2014

Apr 2014----4/31/2014

till december  12/31/2014

3 Replies
Anonymous
Not applicable
Author

Hi,

Like this maybe.

TEST:

LOAD F1,

     Date(MonthEnd([41699]),'M/DD/YYYY') as Date1,

     Sales,

     value

FROM

[..\..\..\..\Downloads\calander.xlsx]

(ooxml, embedded labels, table is Sheet1);

Date1.JPG

Regards.

sunny_talwar

I agree with Jannet Santos‌. You should be able to use MonthEnd function to get to the dates you are looking for.

Not applicable
Author

I am agree too. Regards!