topic Re: Date conversion in load script in QlikView

Date conversion in load script

mtfisch7864 — Thu, 08 Oct 2020 17:30:06 GMT

Hi all,

Can't seem to convert a text timestamp format 'DD MMM YYYY hh:mm:ss' to a timestamp 'MM/DD/YYYY HH:MM:SS'. The 3 character month 'Jan', etc. does not translate to the equivalent month number? What am I doing wrong. I'm using the timestamp function.

Re: Date conversion in load script

Vegar — Thu, 08 Oct 2020 18:57:19 GMT

Check the definitions of your variable MonthNames.

Your short month names (Jan, Feb etc.) need to correspond to the MonthNames system variable.

Re: Date conversion in load script

avinashelite — Thu, 08 Oct 2020 23:50:58 GMT

Try like this

Timestamp (Timestamp#(time_field, 'DD MMM YYYY hh:mm:ss'), 'DD/MM/YYYY hh:mm:ss') as new_field,

If it's not working share the same data

Re: Date conversion in load script

MayilVahanan — Fri, 09 Oct 2020 08:12:00 GMT

HI,

Try like below, it will helps you

Script:

Timestamp(Timestamp#(YourFieldName, 'DD MMM YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss') as YourFieldName

Sample: Timestamp(Timestamp#('09 Sep 2020 16:09:54','DD MMM YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss') gives result as "09/09/2020 16:09:54".

Thanks & Regards,

Mayil Vahanan R

Re: Date conversion in load script

mtfisch7864 — Fri, 09 Oct 2020 13:21:52 GMT

Thank you - works beautifully!

Re: Date conversion in load script

avinashelite — Fri, 09 Oct 2020 13:40:18 GMT

Welcome !!