Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

weekend in Master Calendar

We have volume in Saturday and Sunday. But we want to add saturday volume to friday and sunday volume to monday.

How do we change master calendar for this requirement? We don't want to change anything on the database table.we prefer Changes in the master calendar .

2 Replies
Not applicable
Author

If you only need to fool the system I would add a column in your master calendar with tha new value that you need to point, then use it instead of the old one, so you calendar would look like this:

KeyDayNew Day
11/04/2014FridayFriday
12/04/2014SaturdayFriday
13/04/2014Sunday

Monday

Of course you can change the labels so the new column be the old one, I'm trying to understand what you need and this is what occurs to me but if not please let me know.

MK_QSL
MVP
MVP

You can create a DayFlag in your master calendar script..

IF(WeekDay(Date) = 5, Dual('Fri',4), IF(WeekDay(Date) = 6, Dual('Mon',0), Dual(WeekDay(Date),WeekDay(Date)))) as DayFlag