topic Re: Difference between dates in CMS Development

Difference between dates

ben-duchy — Wed, 11 Nov 2020 17:15:49 GMT

Does anyone know if it's possible to display the difference between 2 sets of dates within HubDB?

So for example if I create 2 date columns, is there any HubL math operators that can calculate how many days difference there are?

Re: Difference between dates

dennisedson — Thu, 12 Nov 2020 16:26:59 GMT

Hiya @ben-duchy !

Does it have to be hubl? Will a js solution work

Re: Difference between dates

piersg — Thu, 12 Nov 2020 16:55:14 GMT

Hi Ben,

I did this to get the length of an event (i.e. difference between two dates):

{% if row.end_datetime %} {% set end_time = unixtimestamp(row.end_datetime) %} {% set start_time = unixtimestamp(row.start_datetime) %} {# get length in hours #} {% set length = (end_time - start_time)//60//60//1000 %} {% if length > 24 %} {% set length = length/24 %} {% set days = length|round(0, 'floor') %} {% set length = days~' days' %} {% elif length > 12 %} {% set length = 'All day event' %} {% elif length == 1 %} {% set length = length~' hour' %} {% elif length < 1 %} {% set length = (end_time - start_time)//60//1000 %} {% set length = length~' minutes' %} {% else %} {% set length = length~' hours' %} {% endif %} {% endif %}

Re: Difference between dates

ben-duchy — Fri, 13 Nov 2020 15:11:28 GMT

Hi @dennisedson,

I don't think JS would work in this case as the data is being stored in HubDB and I'm not sure if you can pull data in from this using JS. Also I'm more comfortable with HubL over JS.

Thanks anyway

Re: Difference between dates

ben-duchy — Fri, 13 Nov 2020 15:12:04 GMT

Hi @piersg, thanks I'll give it a go

Re: Difference between dates

piersg — Fri, 13 Nov 2020 16:17:45 GMT

You just need this to get difference in days really:

{% set end_time = unixtimestamp(row.end_datetime) %} {% set start_time = unixtimestamp(row.start_datetime) %} {% set days = (end_time - start_time)//24//60//60//1000 %}

Re: Difference between dates

ben-duchy — Fri, 13 Nov 2020 16:24:59 GMT

@piersgyou're a genius! Thank you so much!

Re: Difference between dates

piersg — Fri, 13 Nov 2020 16:32:09 GMT

No worries, glad I could help 🙂

Re: Difference between dates

Thrive — Wed, 24 Jul 2024 00:38:54 GMT

Hi there, we have built an app for the marketplace that allows you to automatically calculate the time between 2 dates. Feel free to check it out here: https://ecosystem.hubspot.com/marketplace/apps/marketing/data-management/calculations-3449553