Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

View Upcoming Due Dates Only Weekdays

I am having some trouble with figuring out a formula to display my upcoming order due dates, specifically I want to view the next 5 order dates due but only if they fall on a weekday. I am also tryin...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

You can try to use below measure to get Current weekday range and upcoming weekday range:

Current/Upcoming Week =
VAR temp = [PastDue_Adj]
VAR weekDay =
    WEEKDAY ( temp, 1 )
VAR CurrentWeek = temp + 7
    + ( 2 - weekDay )
    & "~"
    & temp + 7
    + ( 6 - weekDay )
VAR UpcomingWeek =
    TODAY () + 7
        + ( 2 - WEEKDAY ( TODAY (), 1 ) )
        & "~"
        & TODAY () + 7
            + ( 6 - WEEKDAY ( TODAY (), 1 ) )
RETURN
    IF ( temp <> BLANK (), CurrentWeek, IF ( [DeliveredLate] <> 1, UpcomingWeek ) )

 

Regards,

Xiaoxin Sheng