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?
My Date System Variable Format is the Default 'M/D/YYYY'.
I have tried using
Date(OrderDate ,'MM/DD/YYYY') as OrderDate,
From [($(vQVDPath)Test.qvd)] (qvd)
Where Date(OrderDate,'MM/DD/YYYY') = '04/30/2018';
Which will yield the desired formatting in the Front End. I was more just curious as to why the addition of the Where Clause would change the formatting from Date to Num. I believe the format of the OrderDate field is a timestamp which has been formatted Date(OrderDate,'MM/DD/YYYY') but has not had Date(Floor(OrderDate,'MM/DD/YYYY') which I am wondering if this is having an effect.