# Filter using relative date values ("TODAY" etc.) **URL:** \ **Category:** HubSpot Ideas\ **Tags:** object\ **Created:** [January 24, 2017, 12:59pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821 "2017-01-24T12:59:06Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Frank](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/frank/32/9140_2.png) [@Frank](https://community.hubspot.com/u/Frank)\ **Post date:** [January 24, 2017, 12:59pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/1 "2017-01-24T12:59:06Z")
Hi there, we really need to run filters on dates using relative terms like “today”, “yesterday” etc. -- Salesforce has this ability and it’s extrememly useful: [https://help.salesforce.com/articleView?id=custom\_dates.htm](https://help.salesforce.com/articleView?id=custom_dates.htm) Currently, if we want to run a List around our customers who expire _at some point in the future_, we have to go in and change the “after date” fitler each time to update the current date. (The rolling dates filter doesn’t work in this case, because the dates we’re looking for are in the future and not the past.) Hopefully this is easy to do, thanks! ---
**Author:** ![CHARLESM](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/charlesm/32/5125_2.png) [@CHARLESM](https://community.hubspot.com/u/CHARLESM)\ **Post date:** [December 6, 2016, 7:23pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/2 "2016-12-06T19:23:31Z")
THERE NEEDS TO BE A WAY TO USE ROLLING DATES IN THE CRM. use rolling dates for the Last Contacted date on the CRM/Sales side. This would allow me to contact a customer that I have not had contact with in the last 90 days. ---
**Author:** ![dotcoach](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dotcoach/32/28756_2.png) [@dotcoach](https://community.hubspot.com/u/dotcoach)\ **Post date:** [April 30, 2017, 9:17am UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/3 "2017-04-30T09:17:48Z")
I also think that this would be a brilliant addition. So does one of your hubspot forum moderators! [https://community.hubspot.com/t5/CRM/Filtering-by-before-x-months/m-p/13696#M903](https://community.hubspot.com/t5/CRM/Filtering-by-before-x-months/m-p/13696#M903) ---
**Author:** ![Jean](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jean/32/28756_2.png) [@Jean](https://community.hubspot.com/u/Jean)\ **Post date:** [June 8, 2017, 12:23pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/4 "2017-06-08T12:23:29Z")
Just switched to HS Sales and I can’t understand why this isn’t a thing there yet, while in Marketing it is. ---
**Author:** ![OleMartinExilva](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/olemartinexilva/32/31746_2.png) [@OleMartinExilva](https://community.hubspot.com/u/OleMartinExilva)\ **Post date:** [October 6, 2017, 1:22pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/5 "2017-10-06T13:22:42Z")
When adding ‘rolling date’ as an option, please include ‘more than/less than’ at the same time - and make them work together! Like Jean is saying; the function is already part of Marketing, please add it to CRM/Sales as well. Query: _List **deals** where_ ‘Last Activity Date’ _is_ _ **more than** _ _30 days ago._ Sales man: _Thank you, HubSpot! I’ll get right to it!_ And we will all be happy! ---
**Author:** ![clioi](https://avatars.discourse-cdn.com/v4/letter/c/74df32/32.png) [@clioi](https://community.hubspot.com/u/clioi)\ **Post date:** [December 12, 2017, 9:49am UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/6 "2017-12-12T09:49:51Z")
yes please - extend the ‘rolling date’ feature to HubSpot Sales as well! ---
**Author:** ![mpike](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mpike/32/10599_2.png) [@mpike](https://community.hubspot.com/u/mpike)\ **Post date:** [December 18, 2017, 8:05pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/7 "2017-12-18T20:05:49Z")
I agree! This would be very useful. Specifically - I’ve been trying to build ways for our sales guys to filter their contacts based on date last contacted (I can sort based on that - but with 300+ assigned leads, being able to filter would be more useful). I’ve managed a rather painful work around - which is to build the list on the marketing side - and then make the filter on the sales side based on whether they are on the list. But it would be so much easier to have it on the sales side. ---
**Author:** ![zbelcher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zbelcher/32/31639_2.png) [@zbelcher](https://community.hubspot.com/u/zbelcher)\ **Post date:** [December 22, 2017, 4:41pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/8 "2017-12-22T16:41:16Z")
Yes, it is very frustrating and limiting the usefulness of the CRM Platform, especially when you combine this with the inability to set deal properties via workflows (other than a very select few, it seems). If I have a custom deal property (for example “follow-up reminder date”), and I want the workflow to set that property to (for example) 10 days before an existing date property (for example “close date”) I cannot do this easily. You can imagine all sorts of powerful sales workflows that could be built if this functionality was available (send an internal email notification to Hubspot owner and assign a follow-up task 10 days before deal “Close Date”, for example). I could do this easily in Zoho CRM. ---
**Author:** ![aarongarcia1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/aarongarcia1/32/31851_2.png) [@aarongarcia1](https://community.hubspot.com/u/aarongarcia1)\ **Post date:** [February 8, 2018, 4:11pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/9 "2018-02-08T16:11:36Z")
What the heck? Why is this not an option? I need to be able to automate a reminder that lets me know when a close date is drawing near. This is stupid simple… not sure why it’s not a thing yet. ---
**Author:** ![zbelcher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zbelcher/32/31639_2.png) [@zbelcher](https://community.hubspot.com/u/zbelcher)\ **Post date:** [February 9, 2018, 4:27pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/10 "2018-02-09T16:27:34Z")
Any updates Hubspot team?? ---
**Author:** ![mwalsh](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mwalsh/32/35493_2.png) [@mwalsh](https://community.hubspot.com/u/mwalsh)\ **Post date:** [March 1, 2018, 11:17pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/11 "2018-03-01T23:17:46Z")
I’m surprised by the lack of this seemingly basic, fundamental feature. We could really use it to create filter views e.g. to see accounts that haven’t been checked up on in more than 3 months. ---
**Author:** ![NiekDekker](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/niekdekker/32/38114_2.png) [@NiekDekker](https://community.hubspot.com/u/NiekDekker)\ **Post date:** [March 16, 2018, 4:17pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/12 "2018-03-16T16:17:52Z")
Yes, please. I need this too. Both on contact and company property. This simple feature alone will get my sales operations to another level! ---
**Author:** ![Wordna](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/wordna/32/99730_2.png) [@Wordna](https://community.hubspot.com/u/Wordna)\ **Post date:** [April 13, 2018, 9:20pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/13 "2018-04-13T21:20:53Z")
“Last Contacted” is “Last 90 Days” is possible, but I need “Last Contacted” is NOT “Last 90 Days”… ---
**Author:** ![Danielbrinch](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danielbrinch/32/98942_2.png) [@Danielbrinch](https://community.hubspot.com/u/Danielbrinch)\ **Post date:** [July 7, 2018, 4:59pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/14 "2018-07-07T16:59:54Z")
Yes, we need this! Surprised that there isn’t a “IS NOT” “Last 7 days”. ---
**Author:** ![TheoB](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/theob/32/57633_2.png) [@TheoB](https://community.hubspot.com/u/TheoB)\ **Post date:** [August 2, 2018, 8:36am UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/15 "2018-08-02T08:36:33Z")
Agreed, please add rolling date ranges for all date filters - contacts, companies, deals, engagements, etc. ---
**Author:** ![Wordna](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/wordna/32/99730_2.png) [@Wordna](https://community.hubspot.com/u/Wordna)\ **Post date:** [November 12, 2018, 6:00pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/16 "2018-11-12T18:00:30Z")
Have you tried using Lists? HubSpot support helped me create an Active List with “The contact property Last contacted is more than 30 days ago.” ---
**Author:** ![JK1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jk1/32/57754_2.png) [@JK1](https://community.hubspot.com/u/JK1)\ **Post date:** [June 28, 2017, 3:39am UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/17 "2017-06-28T03:39:57Z")
Agreed. The obvious use case being able to filter Deals with a close date in the past (i.e close date before “Today” with the value of Today changing dynamically not needing a manual change) ---
**Author:** ![Daniel1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/daniel1/32/102437_2.png) [@Daniel1](https://community.hubspot.com/u/Daniel1)\ **Post date:** [July 14, 2017, 3:05pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/18 "2017-07-14T15:05:26Z")
Similarly, it would be hugely useful to use relative dates (“today”, etc) to enroll contacts and companies in lists, workflows, etc. We are using Hubspot to facilitate our Product Qualified Lead (PQL) process, so this functionality will make everything much simpler. ---
**Author:** ![Lea](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lea/32/82448_2.png) [@Lea](https://community.hubspot.com/u/Lea)\ **Post date:** [September 28, 2017, 11:34pm UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/19 "2017-09-28T23:34:20Z")
Same here we really need to have rolling date feature on Marketing side of Hubspot to create list. Sales side has it and it is really useful ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [October 4, 2017, 11:08am UTC](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821/20 "2017-10-04T11:08:40Z")
I’d like Smart Lists to contain folks with “Create Date” of, day, “Last Week”…so I don’t have to keep manually changing the hard coded dates every week. (and no, rolling week, “Last Seven Days” does not help me here. I want “Last week” like Filters give, please) That’d make Smart Lists \*really\* Smart 🙂 This would also improve integration with Databox. Cheers, Simon [Next page](https://community.hubspot.com/t/filter-using-relative-date-values-today-etc/821.md?page=2)