Comparing Two Date columns

[kushalb]

Hi Folks,

In My Data I have 2 columns for Date
Date format is different for both Dates
1. date of birthdate = 22-Aug-21
2. Date of upcoming birthday = 2022-08-22

I would like to check if 'Date of upcoming birthday' is exactly one year after 'date of birthdate'

Can anyone guide currently we need a logic as we are using a formula tool to accomplish this but needs a help

Thank you in advance

[FilipR]

First you convert the dates into a proper format, then use the DateTimeDiff to see how many days there are between the two dates.

[Qiu]

@kushalb 
I checked the DateTimeDiff will not work for this case, since I think it gets rounded.
This is a work around.

[binuacs]

@kushalb One way of doing this

[grazitti_sapna · Accepted solution]

@kushalb Another way is you can extract the year part of your data and then check if difference is 1. here is the workflow to achieve this.

Thanks!!

[Qiu]

@binuacs 
The Leap Year has 366 days, 😂

[binuacs]

@Qiu I realized that later and updated the workflow to compare the dates after adding 2 to the birthday year. Thanks for letting me know 😀