Date Time Format

[Karahs]

Hi everyone,

       I want the TAT date and time format to be same as SiteArrivalDate  date and time format!

Thanks!!

[jonathandienst · Accepted solution]

Use an expression like

     Date(Date#(TAT, 'dd MMM yyyy hh:mm:ss:fff'), 'M/d/yyyy hh:mm:ss tt)

This can be in the front end, but it would be better to amend the load script and incorporate the format expression in the LOAD statement:

     LOAD

          ...

          Date(Date#(TAT, 'dd MMM yyyy hh:mm:ss:fff'), 'M/d/yyyy hh:mm:ss tt) as TAT,

          ...

[Karahs]

Thankyou Jonathan ,it worked