formula to calculate events dated last week

Topic Labels: Formulas Views
296 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi everyone,
I'm trying to create a formula field to calculate last week.
I have a view that shows me the events that refer to last week, I added a formula field to calculate all the events that have the "Date" field dated to last week, but it doesn't work in any way, because it continues to insert the camps of the current week. Can someone help me?

1 Reply 1

If you want a formula field that let's you know if a record has a date that lies in the past week, use:

IF({Date field}, IF((WEEKNUM(TODAY())-WEEKNUM({Date field}))=1, "past week"))