Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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.