How do I get the start date of current week?

Ask for Help
1

I want to achieve the following calculated values.
Let’s say User added:
2 articles last week
4 articles this week

How can I calculate that they have increased 100% from (2 to 4 articles) this week.

I am thinking I need to identify the date for this week.
Looked up the community, Weeknum(date) only returns the week that I am in, anyway I can get the starting date of the current week, so I can use the value for query and conditions like within DATE, after DATE.

image

2

image

Start of last week:

N-WEEKDAY(N)+2-7-HOUR(N)/24-MINUTE(N)/1440-SECOND(N)/86400

Start of this week:

N-WEEKDAY(N)+2-HOUR(N)/24-MINUTE(N)/1440-SECOND(N)/86400

With N being the “Now” value. Assuming you start the week on Mondays.

3 Likes
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.