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

[Qiu]

@vijaylnyadav 

Can you at least give us some sample data?

[Emil_Kos]

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. 

[vijaylnyadav]

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

[vijaylnyadav]

Hi, @Emil_Kos 

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

[Emil_Kos · Accepted solution]

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.

[vijaylnyadav]

Hi @Emil_Kos 

Please refer the following sample data.

because the previous i am getting null in the correct date columns.

This is the sample data receiving from user

Date 1	Date 2	Date 3
8-Oct-09	8-Oct-09	8-Oct-09
21-May-19	21-May-19	10-Jun-19
6-Dec-18	6-Dec-18	21-Dec-18
29-May-19	29-May-19	18-Jun-19
2-Aug-17	2-Aug-17	16-Aug-17
25-Feb-15	25-Feb-15	12-Mar-15
17-Jun-19	17-Jun-19	17-Jun-19
29-Jan-18	29-Jan-18	29-Jan-18
6/26/2018	6/26/2018	6/26/2018
5/19/2017	5/19/2017	5/19/2017
5/8/2017	5/8/2017	5/8/2017
5/9/2017	5/9/2017	5/9/2017
7/21/2017	7/21/2017	7/21/2017
7-Mar-08	7-Mar-08	7-Mar-08
1-Oct-03	1-Oct-03	1-Oct-03
7-Aug-07	7-Aug-07	7-Aug-07
13-Mar-14	13-Mar-14	20-Mar-14
27-Aug-12	27-Aug-12	12-Oct-15
27-Aug-12	27-Aug-12	27-Aug-12
11-Nov-08	11-Nov-08	24-Dec-19

[Emil_Kos · Accepted solution]

Hi @vijaylnyadav,

Please find the updated workflow.

[vijaylnyadav]

thankyou @Emil_Kos for this solution.

But what if the user uses another format other than.

Should i use every format instead?

[Emil_Kos]

Hi @vijaylnyadav,

you are not able to Force the user to use one format? The truth is there is always a risk of messing up a month with date. 

if that is possible I would force the user to fill this in one format or at least educate them about preferred format.