Not showing right max date

[Usama]

Hi,

I am not able to get right max date. As per my date field 'Pstng Date' max date should be '11/4/2022' but its showing '12/3/2022'.

Data Source date format: 'MM.DD.YYYY'

Using this to converting to date format: Date(Date#("Pstng Date",'MM.DD.YYYY'),'MM/DD/YYYY') as "Pstng Date"
Also i have tried by using same date format but not wokred.

Frontend Exp: max([Pstng Date])

Any help would be highly appreciated.

Thanks in advance

[hic · Accepted solution]

The 3rd of Dec comes after 4th of Nov, so it is greater. In the choice between these two dates, Max() should return Dec 3rd.