Skip to main content

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?

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"))

Reply


Terms & Conditions