DateTimeAdd to Only Result in a Business Day

[Brian32]

Thank you for looking into my inquiry.

I have an IF Statement that, based on varioius criteria, will subtract a specific number of days, respecitively, from a date column.  I don't want to only subtract Business Days.  All days should be accounted for in the subtraction, but what I need to have happen is that if the resulting date lands on a holiday or weekend I need it to go to the next business day.

Any ideas??

[JohnJPS]

@Paresh1pandya ,

I'm not sure of the details of your issue. It sounds as though you are matching dates where the year is incorrect? If so, you would need to add year information to your data. If you do have year information then the year part of DateTimeToday() should allow you to filter accordingly.

If your issue is something else entirely, please elucidate.

Hope that helps!

John