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

[bundleminion]

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!

[sunny_talwar · Accepted solution]

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

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

[bundleminion]

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 🙂