# Change a property value automatically based on date **URL:** \ **Category:** Tips, Tricks & Best Practices\ **Tags:** professional\ **Created:** [April 24, 2024, 11:12am UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646 "2024-04-24T11:12:45Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![OBetzalel](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OBetzalel](https://community.hubspot.com/u/OBetzalel)\ **Post date:** [April 24, 2024, 11:12am UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/1 "2024-04-24T11:12:45Z")
Hi, I have a dropdown select property value with the values: Yes/No. I have another Date property in a future date. When the date is reached (someday - no user engage with the record) - I want a workflow to change the property value to “No”. Now, we have the professiona hub, and we don’t have the schedule to check the condition everyday. Can this be achieved with our current license? or by an application that I can install?: ![Quicklizard - ARR.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/7/5776c04b435a1fee0baf69754f22e8a20485a2b0.jpeg) Thanks! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 24, 2024, 11:14am UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/2 "2024-04-24T11:14:35Z")
Hi @OBetzalel, This feels like something that could be solved differently and better - can you explain what you’re trying to accomplish by doing this? In any case, creating a workflow could look like this: - Enrollment: [date property] is more than 0 days ago - Actions: Set property value to “Yes” Best regards ---
**Author:** ![OBetzalel](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OBetzalel](https://community.hubspot.com/u/OBetzalel)\ **Post date:** [April 24, 2024, 11:23am UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/3 "2024-04-24T11:23:57Z")
@karstenkoehler Hi 😀, Basically we are using here 2 objects - Company and the related deals. We have a rollup field that rollups a \*rollup\* field on the deal level that sums the “Total ARR” with custom logic. For each deal we have a field with ‘expiration date’ - when its due - we don’t want the rollup on the company level to sum from that deal. only deals where Expiration Date \> Today’s Date. Any suggestions? Thanks!! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 24, 2024, 11:28am UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/4 "2024-04-24T11:28:38Z")
@OBetzalel “Expiration date is more than 0 days ago” should work. That would enroll deals where the expiration date is in the past. ---
**Author:** ![OBetzalel](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OBetzalel](https://community.hubspot.com/u/OBetzalel)\ **Post date:** [April 24, 2024, 1:24pm UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/5 "2024-04-24T13:24:25Z")
@karstenkoehler Okay thanks - last questions: **1.** I set “Inactive date” is more than 0 days ago (Past date) - So after the April 25th, a checkbox field will be changed to “No” - Means it doesn’t meet the condition of the rollup to sum the amount. But one thing - the workflow doesn’t work for **Manual** changes, it will work when I will check the record in 2 days? (26th?) ![OBetzalel_2-1713965158075.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/4/f461211d324a71e4dc17c0ef1e9827b2382640c1.png) Currently the property condition is sets to “Yes” (future date - 25th): ![OBetzalel_0-1713964824708.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/a/ba152cb71d6965fbef97d83facd225154385b59a.png) 2. So If i have a record with a future date, I should set this condition: ’ “Inactive Date” is **less** than 0 days ago ’ - Will it work to set the condition to “Yes” since it’s a **future** date? - That’s how we check if a date is in the future? no matter how much days there is until we reach that date? (by the way, what could mean if i change it to is less than 1 days ago or 2 days ago?) ![OBetzalel_1-1713964876219.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/9/d9a66f402f38e32c146c7b495ab1be65c92154a9.png) Thanks my friend! 😀 ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 24, 2024, 1:28pm UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/6 "2024-04-24T13:28:01Z")
@OBetzalel you lost me here, I think I don’t have all of the context I need to answer this. “the workflow doesn’t work for **Manual** changes” - it should, why wouldn’t it? “So If i have a record with a future date, I should set this condition” - which behavior exactly do you want to achieve? Can you give an example? ---
**Author:** ![OBetzalel](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OBetzalel](https://community.hubspot.com/u/OBetzalel)\ **Post date:** [April 24, 2024, 1:33pm UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/7 "2024-04-24T13:33:13Z")
@karstenkoehler Okay I will try to simplify my question - For the example - Today we are on April 24th. 1. To check if “Inactive Date” (Expiration Date) is in the **past** I apply the criteria: “Inactive Date is more than 0 days ago”. **Example** : If ‘Inactive Date’ is on April 20th it should be changed to “No” since it’s in the past. 2. To check if “Inactive Date” (Expiration Date) is in the **future** I apply the criteria: “Inactive Date is less than 0 days ago”. **Example** : If ‘Inactive Date’ is on April 25th it should be changed to “Yes” since it’s in the future. Thanks! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 24, 2024, 2:13pm UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/8 "2024-04-24T14:13:10Z")
@OBetzalel 1. Correct 2. No, this would have to be changed to “is more than 0 days from now” 🙂 ---
**Author:** ![OBetzalel](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OBetzalel](https://community.hubspot.com/u/OBetzalel)\ **Post date:** [April 24, 2024, 2:18pm UTC](https://community.hubspot.com/t/change-a-property-value-automatically-based-on-date/105646/9 "2024-04-24T14:18:16Z")
@karstenkoehler Thank you so much!