Fantastic - that worked thanks Alan 🙂

Hi Alan,

Thanks for the reply.

The script you provided returns the following results:

calDate workingDay ...

Sorry it's the difference in days not months but only where the Working Day flag is set to 'Y'

Hi Alan/Mike,

Following on from this, I'm looking to add a DATEDIFF calculation between today's date 'GETDATE()' and each individual date but only where the Working Day flag is set to...

Great that worked thanks Alan