I have a date field in DD/MM/YYYY 0:00 format.
How do I get QS to correctly read that format. I changed the SET to
SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';
and I tried
Thanks in advance
I think I got it
Date(alt(Date#(DateOfTransaction, 'DD/MM/YYYY hh:mm')), 'DD/MM/YYYY') as TrnsDate,
I then added a master calendar and the dates look correct.
Please make your question as answered,please.
Also it is better to add floor() to round off the time if you do not require it. Not sure why you added Alt(), I think it is not required here.
Date(Floor(Date#(DateOfTransaction, 'DD/MM/YYYY hh:mm')), 'DD/MM/YYYY')as TrnsDate,
Also suggest you reading this blog post:
The Master Time Table
Retrieving data ...