topic Re: Date field format correction in QlikView

Date field format correction

khan_imran — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am getting below information in Date which from system. Now, I want to convert it into MM/DD/YYY hh:mm:ss format.

Fri Jan 1 00:00:56 2016.262 (Day,Month, Date, hh:mm:ss, Year, ms)

Kindly assist me on this.

Regards,

Imran Khan

Re: Date field format correction

swuehl — Sun, 20 Nov 2016 11:30:18 GMT

Maybe like this

=Timestamp(Timestamp#(Subfield(Mid('Fri Jan 1 00:00:56 2016.262',5),'.',1),'MMM D hh:mm:ss YYYY'),'MM/DD/YYYY hh:mm:ss')

[there are different approaches possible to interpret your input value, but basically, use interpretation timestamp#() function on the relevant part of your input value and format using timestamp()

For example, if you want to keep the milliseconds in the numeric representation:

=Timestamp(Timestamp#(Mid('Fri Jan 1 00:00:56 2016.262',5),'MMM D hh:mm:ss YYYY.fff'),'MM/DD/YYYY hh:mm:ss')

]

Get the Dates Right

Why don’t my dates work?

Re: Date field format correction

khan_imran — Sun, 20 Nov 2016 12:09:52 GMT

Thanks Stefan.. It worked.