{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/bc04304a951e49c1b95571cafbe668a2\" frameborder=\"0\" width=\"1898\" height=\"1423\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1423,"width":1898,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1423,"thumbnail_width":1898,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/bc04304a951e49c1b95571cafbe668a2-1ba931860a19e06c.gif","duration":97.812,"title":"'Time since' and 'time until' calculated properties - demo 10/25","description":"Updated demo video from 1/6/2025: https://www.loom.com/share/1fea95e0dd984b8d8cfc86ede7b3e0dd?sid=7a0fbc5c-eb81-4581-853e-56446687f4cf\n\nYou will now be able to create two new types of calculated properties:\n\nTime Since\nTime Until\n\nObject Settings > Properties > Field Type > Calculation > Time Since / Time Until\n\nOnce you have selected ‘Time Since’ or ‘Time Until’, select a custom or default Date or DateTime property as the input for this property. Once this property is created, you cannot switch between Time Since and Time Until calculations.\n\nFor example, if you select ‘Create Date’, the newly created property will display ‘Time Since Create Date’ as its value. This value can be negative or positive (for example, if the date selected is after today, ‘time since’ would display as a negative value).\n\nNotes:\n\nTime Since and Time Until properties cannot be used in calculated properties or as the inputs in rollup properties. They can be used in sync properties.\nIn the early stage of this beta, you will not be able to filter on these properties. Filters support will be added later. \nYou will not be able to create custom field mappings for these properties.\nThese properties will not be available in the Datasets tool.\nThese properties are not yet supported in the Mobile app or Forms.\n\nKB: https://knowledge.hubspot.com/properties/use-todays-date-in-the-crm"}