Date Floor Yielding Different Results on Same Field

m_perreault — Tue, 08 May 2018 16:54:16 GMT

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

Re: Date Floor Yielding Different Results on Same Field

Chanty4u — Tue, 08 May 2018 17:01:14 GMT

can you share sample data

Floor Function

topic Date Floor Yielding Different Results on Same Field in App Development

Date Floor Yielding Different Results on Same Field

Re: Date Floor Yielding Different Results on Same Field