Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a date field in DD/MM/YYYY 0:00 format.
DateOfTransaction |
23/04/2016 0:00 |
How do I get QS to correctly read that format. I changed the SET to
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';
and I tried
Date(DateOfTransaction), 'DD/MM/YYYY',
Thanks in advance
HI
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.
HI
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.
Hi,
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,
Regards,
Jagan.
Also suggest you reading this blog post: