topic Re: Date format in QlikView

Date format

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

Hi All,

Have some problem with date format.

I have tried with alt and date functions but am not getting perfect solution

want to show date with same format everything should be in timestamp fomat

I have attached my requirement below

Re: Date format

sunny_talwar — Tue, 11 Oct 2016 15:31:35 GMT

Try this:

Temp:

LOAD Date,

Date(Floor(Alt(Date(Date), Date#(Date,'MM/DD/YYYY hh:mm'), Date#(Date, 'DD/MM/YYYY hh:mm:ss TT')))) AS DATE,

TimeStamp(Alt(Date(Date), Date#(Date,'MM/DD/YYYY hh:mm'), Date#(Date, 'DD/MM/YYYY hh:mm:ss TT'))) AS TimeStamp

FROM

source.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Date format

hari8088 — Tue, 11 Oct 2016 15:41:25 GMT

it's working fine but in my case i am loading data from sql server there date format is same but few dates are in date format few are in text format means some dates are showing left side some dates are showing in right side in list box.

In this case your formula will work on that?

Re: Date format

sunny_talwar — Tue, 11 Oct 2016 16:07:24 GMT

It should work, have you given it a try? If it doesn't work, please post a snapshot of raw date field to see what is not getting properly interpreted.

Why don’t my dates work?

Get the Dates Right