Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kshitijas
New Contributor III

Date Time Format

Hi everyone,

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

Time date.png

Thanks!!

1 Solution

Accepted Solutions
MVP
MVP

Re: Date Time Format

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,

          ...

2 Replies
MVP
MVP

Re: Date Time Format

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,

          ...

kshitijas
New Contributor III

Re: Date Time Format

Thankyou Jonathan ,it worked