Date Comparison

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

Datasets

Accepted answers

Hi,

I have created a correct date format for each of the columns.

Next time I promise myself that I will go out from my comfort zone and use the formula tool as I have used tons of date-time tools.

Date format.yxmd

Hi @vijaylnyadav,

Please find the updated workflow.

Date format 2.1.yxmd

All comments

Can you at least give us some sample data?

Hi @vijaylnyadav,

I would create a new column with the proper date format and keep the original one.

The new one would be used for calculations but you can remove it along the way.

Hi, @Qiu please find below the attached data.

Condition:

Date 1 <= Date 2 <= Date 3.

Date 1	Date 2	Date 3
29-May-19	29-May-19	4-Jun-19
28-May-19	28-May-19	24-Jun-19
24-Apr-15	24-Apr-15	1-May-15
29/8/11	29-Sep-17	10/30/17
27-Oct-14	27-Oct-14	10-Nov-14
17-Jun-19	17-Jun-19	3-Jul-19
30-11-2017	30-Nov-17	12/01/2017
17-Jun-19	17-Jun-19	3-Jul-19

but how to create a new column if we dont know the date format from users.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703