Discussion Board for collaboration related to QlikView App Development.
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
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
(ooxml, embedded labels, table is Sheet1);
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?
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