4 Replies Latest reply: May 9, 2018 12:06 PM by Mark Perreault RSS

    Date's Reformatted Following a Where Clause

    Mark Perreault

      Hi All,


      I am loading data from a QVD and when I load it as is my dates are formatted 'MM/DD/YYYY' on the Front End.  However when I use a where clause in the load such as Where OrderDate = '04/30/2018'.  My dates become formatted as numbers in the front end so '04/30/2018' becomes 43220.  Does anyone know why adding a where clause would change the formatting of the date?

       

      Thanks,
      Mark