SSRS FetchXML number of days between 2 dates excluding weekends

Asked Jan 27 '23 at 12:46

Active Jan 27 '23 at 12:46

Viewed 36 times

I have 2 fields of DateTime from CRM 365 Online and want to create a custom report with a textbox that calculates the number of days between 2 dates excluding weekends in FetchXML (Bonus to also exclude holidays from the standard holiday schedule)

Any ideas?

asked Jan 27 '23 at 12:46

NDevBrad

In FetchXML this is not possible. – Henk van Boeijen Jan 31 '23 at 13:48
Thanks, i ended up creating a scheduled Flow once a day that calculates the mentioned days and pulled the field for my report – NDevBrad Feb 01 '23 at 14:38

SSRS FetchXML number of days between 2 dates excluding weekends

0 Answers0