Date Comparison

[vijaylnyadav]

Hi,

I want to compare dates which is in a string format because the date time format is not fixed.

I am using simple >= logic but it is not working.

date1, date2, and date3 are the three columns but when they are equal it is validating but when they are not equal they are not validating.

Please suggest me some workflow.

Note: Date format is not fixed

[vijaylnyadav]

@Emil_Kos 

if in a company the users use every possible format where the format are not set.

Than in that case this workflow will not work.

If you have any alternate solution in this case than please suggest.

Thanks Once Again

[Emil_Kos]

Hi @vijaylnyadav,

If the users have a possibility to put any date format he will imagine you aren't able to be 100% sure that you will identify the data correctly.

If the users will use 1/3/2020 you cannot be one hundred percent if the mont is march or June. 

What I would suggest is getting one standardized format for the future data as you will never be able to properly parse all positions due to the issue that I described.