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

    Date DD/MM/YYYY

    Jim Harder


        I have a date field in DD/MM/YYYY 0:00 format. 

      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