Comparing Two Date columns

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

Workflow

Datasets

Tips and Tricks

Date Time

Data Investigation

Accepted answers

grazitti_sapna

@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!!

New Workflow45.yxmd

All comments

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.

New Workflow1d.yxmd

Qiu

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

0913-kushalb.yxmd

binu_acs

@kushalb One way of doing this

DateDiff_0913.yxmd

grazitti_sapna

@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!!

New Workflow45.yxmd

Qiu

@binu_acs
The Leap Year has 366 days, 😂

binu_acs

@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 😀

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703