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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Anonymous however it's not quite what I was hoping to achieve. Ideally I am wanting to only display in the Day 1-5 upcoming orders for weekdays and on the Upcoming Due display the upcoming weeks orders.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    Which date you used check as the condition to switch the date range? If you can please use the static date value. It may get the wrong result if you combine use multiple measures who contains specific filters.

     

    Regards,

    Xiaoxin Sheng