lastest Date

[ZahibSidiq]

Hello,   I have three dates, where I want to find which one of them is the lastest.  I would appreciate very much if you could help me solve it.    Date looks like this: 19.12.2018 06.10.2013 23.05.2018   BR  Zahib 

[AndreyKudinov]

Format them into YYYYMMDD and find max value.

[ZahibSidiq]

Have you tried and did it work? because while I try to convert the date to YYYYMMDD using FormatDate, I get error massage which say something like could not convert to number.    could you please send me a screenshot of the steps. thank you

[MichalSzumski]

Hi Zahib,   I have used below expression and it worked:   FormatDate("5.30.2019", "yyyyMMdd"). It was important to use system date format as an input.   Best regards  Michal Szumski

[ZahibSidiq]

I found out the reason for the error message.. my question is, what will be the fastest way to find the max value between them?