Difference between dates

Develop, Build & Integrate CMS Development
1

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?

2

Hiya @ben-duchy !

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

3

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

4

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 %}
5

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

6

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 %}
7

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

8

No worries, glad I could help :slightly_smiling_face:

9

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: HubSpot Marketplace