x Want to participate? Join the group to interact

Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

General Discussion Sage 4gl command that reads weekdays only

State Verified Answer
Replies 3 replies
Subscribers 138 subscribers
Views 994 views
Users 0 members are here

Browse Forums

237

topics

29

replies

General Discussion

5k

topics

13k

replies

Sage Data & Analytics

56

topics

95

replies

Sage Enterprise Intelligence

211

topics

418

replies

Sage Intelligence Reporting

121

topics

322

replies

Sage 4gl command that reads weekdays only

SOLVED

Posted By ChrisCC over 5 years ago

Has anybody found a way to do calculations for a date that will only take into account weekdays, and ignore the weekends via 4gl?

Top Replies

Israel Braunfeld over 5 years ago +2 verified

You can check the day number of the date by using dayn(date), 1-5 are weekdays Mon-Fri, 6 and 7 are weekends Sat and Sun

+1 Israel Braunfeld over 5 years ago

verified answer

You can check the day number of the date by using dayn(date), 1-5 are weekdays Mon-Fri, 6 and 7 are weekends Sat and Sun
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 ChrisCC over 5 years ago in reply to Israel Braunfeld

any ideas on how to identify holidays?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aziz ELFA over 5 years ago

you have already some prebuild program to do that fron the standard. Look to how the system is using the calendar of hollydays for each site in sage to calculate the delivery date...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel