Date DD/MM/YYYY

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[robert_mika]

Please make your question as answered,please.

[jagan]

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.

[MindaugasBacius]

Also suggest you reading this blog post:

The Master Time Table