Date format

[hari8088]

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

[sunny_talwar]

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);

[hari8088]

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?

[sunny_talwar]

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