Skip to Content
0
Jul 19, 2016 at 11:32 AM

Exclude weekends from calendar day variables range

554 Views

Hello experts,

I've got query with 0CALDAY characteristic in the Filters (Char. Restrictions),

  • This characteristic is restricted by two customer exit variables included in one range:
    • Between:
      • calday_period_start ("From Date", set by default to "sy-datum - 3months")
      • calday_period_end ("To Date", set by default to "sy-datum - 1day")

The 0CALDAY is also used as the only characteristic in the Query Rows.

Could you please tell what would be the best way to exclude weekend days (Saturday, Sunday) from the rows in the selected period between two dates specified by the user on query execution?

Would you be so kind and tell if I have to modify start/end date customer exits in ~cmod or if there is some more convenient way?

Regards,
Sebastian

Attachments