# Substract X amount of weeks

**URL:** <https://community.dremio.com/t/substract-x-amount-of-weeks/7277>\
**Category:** Uncategorized\
**Created:** [April 12, 2021, 7:18am UTC](https://community.dremio.com/t/substract-x-amount-of-weeks/7277 "2021-04-12T07:18:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chun2869](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@chun2869](https://community.dremio.com/u/chun2869)\
**Post date:** [April 12, 2021, 7:18am UTC](https://community.dremio.com/t/substract-x-amount-of-weeks/7277/1 "2021-04-12T07:18:24Z")

</div>

As the subject, how do I subtract 5 weeks from the current date?

I was able to use  
SELECT TIMESTAMPADD( YEAR, -1, CURRENT\_DATE)

however, I got “SQL Error: PARSE ERROR: Failure parsing the query” error by changing YEAR to week or ‘week’.

SELECT TIMESTAMPADD( week, -1, CURRENT\_DATE)  
SELECT TIMESTAMPADD( ‘week’, -1, CURRENT\_DATE)

what am I supposed to do if I want to subtract 5 weeks from today?

thank you

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [April 14, 2021, 4:52am UTC](https://community.dremio.com/t/substract-x-amount-of-weeks/7277/2 "2021-04-14T04:52:37Z")

</div>

@chun2869

You can use DAY or MONTH

`select DATE_SUB(now(), INTERVAL '10' DAY)`  
`select DATE_SUB(now(), INTERVAL '10' MONTH)`