Jet Report _ Report dates exclude Weekends and Holidays

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I use NAV 2013 and Jet Essentials. I want to create a report which needs to exclude weekends and holidays. I only know in Datefilter "<>date". But I will need to type in all the weekends and holiday "<>date&<>date&...."

Is there other simple way to exclude all weekends and holidays?

Thank you!

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (1)

Report

RE: Jet Report _ Report dates exclude Weekends and Holidays

Thank you for your help! I understand now. I can also create a excel calendar table and use Pivot Table.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Jet Report _ Report dates exclude Weekends and Holidays

If you license permits, you can enter all your holidays & week-offs in "Shop Calendar Holiday" Table (ID - 99000753) one time. Or create separate table to capture these details.

In this way, you can join the query with this table and exclude these particular dates in the report.