9 Replies Latest reply: Jul 5, 2011 6:11 PM by Bikash Debnath RSS

    Date format conversion

      Hi All,

       

      how can i convert DD/MMM/YYYY format into MM/DD/YYYY in QV? What would my expression look like?

      ex: my date field looks like this: 02/Jun/2011 or 05/Jul/2011

       

      The month is always 3 letters.

      My set statement is SET DateFormat='M/D/YYYY'  --- which i need for the other queries.

       

      So can i use another SET statement just before running this query (which i tried and didnt work) or can i convert the format using an expression?

       

       

       

      Thanks.