How Do I Remove Public Holidays in a Date Range – Design

How Can We Help?

< Back

Answer

Create a table with public days details and use them in the query to exclude those days from a date range.

For Example:

select count(*) from xx_publicHolidays where (date, between @startdate and @ endDate)

Date in the where condition is the column name in the table.

Comments are closed.

This is the legacy version of the XMPro Documentation site. For the latest XMPro documentation, please visit documentation.xmpro.com

X