4 Replies Latest reply: Oct 31, 2016 4:54 AM by Mindaugas Bacius RSS

    Date DD/MM/YYYY

    Jim Harder

      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