Update a Field Comparing Date field from another Dataset

[DataPirate26]

Hello, 

Can someone help me to Update the Field Margin in File 1 comparing with File 2 Months Field. 

The logic used would be We have to check Today's Date first and then pull the Date from File 2 which is closest to Today's Date. So the date closest to days's date is 15th August 2022. So the Margin field in File 1 would be updated to 15th August 2022. 

Test workflow attached below. can someone help me out with a solution. 

[grazitti_sapna · Accepted solution]

@DataPirate26, try this.

I hope this helps!

Thanks!

[DataPirate26]

@grazitti_sapna Thank you for your quick resolution. I was trying to find out the difference of the days and then take the Minimum value but this is much optimised solution. 

[grazitti_sapna]

@DataPirate26, you're welcome. I am glad it worked for you.

Thanks!