Forum Discussion

StevesHelp's avatar
StevesHelp
Helper I
8 years ago
Solved

Stop data prior to this week

I've been using:

 

No Future = Date'date'>today()

 

But since my data refreshs once a week, I'd like it to stop at the previous Saturday of the week but I'm not sure how to word that.

 

Any help?

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi StevesHelp,

     

    Try with this formula:

    sunday =
TODAY () - ( WEEKDAY ( TODAY (); 2 ) )

    This will return today minus the number of days from Sunday, where Monday = 1, Tuesday = 2... etc.

     

    Regards.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi StevesHelp,

     

    Try with this formula:

    sunday =
TODAY () - ( WEEKDAY ( TODAY (); 2 ) )

    This will return today minus the number of days from Sunday, where Monday = 1, Tuesday = 2... etc.

     

    Regards.