Hi All,
I have the below script;
Final
Load
Date(Floor([Data As of Date]),'MM/DD/YYYY') as [Data As of Date],
Date(Floor([Data As of Date]),'MM/DD/YYYY') as [Data As of Date_Test]
Resident temp;
The front end of the table yields different results for these two fields. [Data As of Date] is formatted 'M/D/YYYY' and [Data As of Date_Test] is formatted 'MM/DD/YYYY'. Does anyone know why this would be happening
| Data As of Date | Data As of Date_Test |
|---|
| 5/7/2018 | 05/07/2018 |
| 5/8/2018 | 05/08/2018 |
| 5/9/2018 | 05/09/2018 |
Thanks,
Mark
