weekends. I searched forum and found my topic without answer

randrews

I need to make report with using working days. I saw base calendar - it uses table Date. I can't see codeunits and C/AL code in forms. So I want to know to questions (DateVariable is of type Date).
1) How to know whether DateVariable is weekend or nonworking.
1) How to know the next working date after DateVariable.

I searched forum and found likely topic without answer:
http://www.mibuso.com/forum/viewtopic.p ... ht=weekend

samer

Hello randrews,

In table "Date" you can find another field called "Period No." and this field make difference between working and nonworking days example :
Manday = 1
Zonday = 7 use Ctrl+F8.

Regarding to your second question use navision function CALCDATE.

Best of luck.

randrews

Table 7601 "Base Calendar Change" and function DATE2DMY helps me.

Thanks for replying.