topic Re: Converting a Macro Datetime format into Qlik readable timestamp in QlikView

Converting a Macro Datetime format into Qlik readable timestamp

pranaview — Sat, 16 Nov 2024 04:01:28 GMT

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

Re: Converting a Macro Datetime format into Qlik readable timestamp

PrashantSangle — Thu, 28 Mar 2019 12:39:16 GMT

Timestamp(Timestamp#(FileBaseName(),'DD-MM-YYYY hh mm TT'),'YourRequiredFormat') as datetime;

Regards,
Prashant Sangle

Re: Converting a Macro Datetime format into Qlik readable timestamp

pranaview — Thu, 28 Mar 2019 13:25:54 GMT

Thanks Prashant, that worked just fine!