Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try Date#() function to help Qlik understand your date format
Date#(BeginningDate, 'DDMMMYYYY')-Date#(EndDate, 'DDMMMYYYY') as Days
Try Date#() function to help Qlik understand your date format
Date#(BeginningDate, 'DDMMMYYYY')-Date#(EndDate, 'DDMMMYYYY') as Days
Thank you so much!
Still very new to Qlik so I really appreciate the patience with my "duh" questions haha.
We all have been there, beside there are no 'duh' questions in our quest to learn 🙂