# HubDB wrong time displayed on page

**URL:** <https://community.hubspot.com/t/hubdb-wrong-time-displayed-on-page/79560>\
**Category:** CMS Development\
**Tags:** enterprise\
**Created:** [April 18, 2023, 4:29pm UTC](https://community.hubspot.com/t/hubdb-wrong-time-displayed-on-page/79560 "2023-04-18T16:29:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KCadi](https://avatars.discourse-cdn.com/v4/letter/k/bc79bd/32.png) [@KCadi](https://community.hubspot.com/u/KCadi)\
**Post date:** [April 18, 2023, 4:29pm UTC](https://community.hubspot.com/t/hubdb-wrong-time-displayed-on-page/79560/1 "2023-04-18T16:29:27Z")

</div>

Hello all,

I have a HubDB for physical events and to display them on dynamic pages. BUT i have an issue.  
I have a column in my HubDB that is in Date and time format that has this input :

 ![Capture d’écran 2023-04-18 à 18.27.06.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/c/1cfd03d0ef5d24ef03cac63594fd882a403e9f0c.png)

The code that displays it is this one :

And the result is this :

 ![Capture d’écran 2023-04-18 à 18.28.20.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/5/5908b32246cff7c20070c48eb38d87c349880bbd.png)

I don’t know why it adds 5 minutes to the time i selected on the display page.  
I tried inputting 1:55PM in HubDB but it displays me 1:05PM

Any idea on how i can fix this please ?  
Thank you

---

<div class="post-metadata">

**Author:** ![Kevin-C](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kevin-c/32/34570_2.png) [@Kevin-C](https://community.hubspot.com/u/Kevin-C)\
**Post date:** [April 18, 2023, 6:42pm UTC](https://community.hubspot.com/t/hubdb-wrong-time-displayed-on-page/79560/2 "2023-04-18T18:42:41Z")

</div>

Hey @KCadi

The issue is that the “%m” directive is for zero-padded month. Try using the directive “ **%M** ”, with a capital “M”.

![KevinC_1-1681843393873.png](https://d2qpr2jzcazej7.cloudfront.net/optimized/3X/d/6/d6f19c04c086d8d6efa904b66f65fb0c2e9629eb_2_690x86.png)

![KevinC_2-1681843405228.png](https://d2qpr2jzcazej7.cloudfront.net/optimized/3X/f/f/ffa84dcb0ccec369e2ec159ba0320da09f1923ed_2_690x84.png)

Worth noting that the datetimeformat filter is depreciated and you’ll want to use the [format\_datetime filter.](https://developers.hubspot.com/docs/cms/hubl/filters#format-datetime)

Hope this gets you moving!

---

<div class="post-metadata">

**Author:** ![KCadi](https://avatars.discourse-cdn.com/v4/letter/k/bc79bd/32.png) [@KCadi](https://community.hubspot.com/u/KCadi)\
**Post date:** [April 19, 2023, 7:32am UTC](https://community.hubspot.com/t/hubdb-wrong-time-displayed-on-page/79560/3 "2023-04-19T07:32:19Z")

</div>

Hey @Kevin-C

Thank you for your answer, it fixed my issue 🙂