Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am getting an macro-enabled excel file which has the date and time in the file name which I require to load in to qlik using FileBaseName() function.
The date time format is as such "dd-mm-yyyy hh mm AMPM" for ex: 28-03-2019 04 32 PM
Now when i'm loading it into qlik, i need to convert it into a proper date time format. Kindly let me know what function or combination of functions that i can use to achieve this.
Thanks for the support!
Pranav