Forum Discussion

NewbieJono's avatar
NewbieJono
Icon for Post Partisan rankPost Partisan
2 years ago
Solved

Flag past 26 Weeks

is there a method i can flag the date in a calendar table if its in the past 26 weeks, but I only want to set the flag if there is a full 7 days.

 

so a week would have to be the whole Mon - Sunday.

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    NewbieJono , create a new columns

    New column =

    var _end = [Date] - Weekday([Date],2) +7

    var _max = if([Date]= _end, _end , _end-7)

    var _min = _max - 26*7 +1

    return

    if([Date]>= _min && [Date]<=_max, "Last 26 Week", "Others")

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    NewbieJono , create a new columns

    New column =

    var _end = [Date] - Weekday([Date],2) +7

    var _max = if([Date]= _end, _end , _end-7)

    var _min = _max - 26*7 +1

    return

    if([Date]>= _min && [Date]<=_max, "Last 26 Week", "Others")