# How do I get the start date of current week?

**URL:** <https://community.glideapps.com/t/how-do-i-get-the-start-date-of-current-week/71488>\
**Category:** Ask for Help\
**Created:** [March 7, 2024, 3:12am UTC](https://community.glideapps.com/t/how-do-i-get-the-start-date-of-current-week/71488 "2024-03-07T03:12:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin)\
**Post date:** [March 7, 2024, 3:12am UTC](https://community.glideapps.com/t/how-do-i-get-the-start-date-of-current-week/71488/1 "2024-03-07T03:12:36Z")

</div>

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/91b8b1fa326bcf9207128bcf78722bea73337974.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 7, 2024, 11:43pm UTC](https://community.glideapps.com/t/how-do-i-get-the-start-date-of-current-week/71488/2 "2024-03-07T23:43:04Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2e27aa898da2d40621948d266b16b7374fadf9c.png)

Start of last week:

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

```

Start of this week:

```auto
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.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 14, 2024, 11:43pm UTC](https://community.glideapps.com/t/how-do-i-get-the-start-date-of-current-week/71488/3 "2024-03-14T23:43:51Z")

</div>

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