# Problem with format\_date

**URL:** <https://community.hubspot.com/t/problem-with-format-date/97623>\
**Category:** CMS Development\
**Created:** [January 11, 2024, 4:16pm UTC](https://community.hubspot.com/t/problem-with-format-date/97623 "2024-01-11T16:16:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SLosi](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@SLosi](https://community.hubspot.com/u/SLosi)\
**Post date:** [January 11, 2024, 4:16pm UTC](https://community.hubspot.com/t/problem-with-format-date/97623/1 "2024-01-11T16:16:56Z")

</div>

Hi all, I have a problem with format\_date filter:

- I create a custom object called **fatture**

- this custom object has a property called **emissione**. This is a type **Date picker**

- In my custom module I get last result of the **fatture** associations by logged contact ID

- In the custom module, I try to format the value **emissione** , but format\_date not working because if I use it, I don’t see any value

- If I try to write **last\_billing.emissione | pprint** , I see that **emissione** is a string value, not a date object. I think this is my problem, but don’t know how to fix and if there is a workaround to convert date (for example): from **01/01/2024** to **01 January 2024**.

Thanks

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [January 16, 2024, 7:11pm UTC](https://community.hubspot.com/t/problem-with-format-date/97623/2 "2024-01-16T19:11:52Z")

</div>

Hi, @SLosi 👋 Welcome to the community.

The issue you are having is due to the property field-type. If you need a datetime field-type, you’ll need to create it via our API (this specific property type cannot be created in-app.) It is not possible to convert an existing property, you’ll need to create a new property via our API and use it moving forward. We’ll leave this open in case there are community members who’ve found a workaround outside the documentation. — [Create a datetime property](https://developers.hubspot.com/docs/api/faq#:~:text=Because%20date%20picker%20properties%20created,properties%20using%20the%20property%20endpoints.)

Best,

Jaycee
