Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bundleminion
Contributor II
Contributor II

How do I convert "01Jan2020" date format to "01/01/2020" format?

Hello again,

I am importing and compiling over 150 data files and need to do a "EndDate - BeginningDate = Days" calculation to get a field which tells me how many days the service provided took.

Example:

BeginningDate                EndDate                  Days

   01/01/2020                   01/05/2020                 5

My issue is that the date format in these files is "01Jan2020" so I need help to convert that to either a "43831" or a "01/01/2020" format in an efficient way.

Thanks in advance for your help!

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

Try Date#() function to help Qlik understand your date format

Date#(BeginningDate, 'DDMMMYYYY')-Date#(EndDate, 'DDMMMYYYY') as Days

 

View solution in original post

3 Replies
sunny_talwar

Try Date#() function to help Qlik understand your date format

Date#(BeginningDate, 'DDMMMYYYY')-Date#(EndDate, 'DDMMMYYYY') as Days

 

View solution in original post

bundleminion
Contributor II
Contributor II
Author

Thank you so much!

Still very new to Qlik so I really appreciate the patience with my "duh" questions haha.

sunny_talwar

We all have been there, beside there are no 'duh' questions in our quest to learn 🙂