Discussion board where members can get started with Qlik Sense.
I want the TAT date and time format to be same as SiteArrivalDate date and time format!
Go to 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:
Date(Date#(TAT, 'dd MMM yyyy hh:mm:ss:fff'), 'M/d/yyyy hh:mm:ss tt) as TAT,
Thankyou Jonathan ,it worked