Matching date within a date range

[aka_ash]

Hi,

I am currently performing a reconciliation between 2 sources and have a date that i would like to match with a 4 day tolerance.

I currently have a join tool performing the matching configured to join on specific fields.

I have a attached an example workflow and sample data, it is currently doing exact matching on the date, is it possible to apply an allowance for 4 day tolerance match for the date?

There are currently 2 matches, with the a 4 day tolerance i expect a couple more.

Thanks in advance,

Ash

[LordNeilLord · Accepted solution]

Hey @aka_ash 

I would approach this by first joining all of your data together using the primary key (and not the date) the use a datediff calculation to filter anything that is upto 4 days difference....someting like this:

Then you can use a filter to adjust to the tolerance required

[grazitti_sapna · Accepted solution]

Hi @aka_ash , Please refer to the screenshot and workflow for your concerns.

[aka_ash]

Thanks @LordNeilLord and @grazitti_sapna ,

I believe I can utilise this method to get the desired result.

Thanks Again,

Ash

[MikeLR]

Great answers thanks @LordNeilLord  and @grazitti_sapna    I've been struggling with the same issue as @aka_ash  and just found this post.