Format date with words

[JGrace8]

Hello,

I am inserting dates into email templates using Personalization tokens.

The date comes out like so:

2025-07-05.

I want it to come out as:

July 5, 2025

For the life of me I can't figure out how to get HubSpot to format the date this way.

If I go into Settings > Account Defaults > User defaults

The "Date and number format" drop down shows a list of countries. I believe this is for determining if month or day should go first? If so, that is not what I'm trying to adjust.

How do I get the dates to show up with words for the month names, not with numbers?

The purpose is to sound human and conversational in the email.

For example, instead of saying "Hi! I got your order on 2025-06-05."

I want to say, "Hi, I got your order on July 5, 2025"

Right now I have to manually adjust it for every email.

Thank you for any help this community can offer.

[karstenkoehler · Accepted solution]

Hi @JGrace8,

The date format for personalization tokens in emails is determined by the numbers format you choose for your account: Settings > Account defaults > User defaults > Date and number format

---

@JGrace8 wrote:

The "Date and number format" drop down shows a list of countries. I believe this is for determining if month or day should go first? If so, that is not what I'm trying to adjust.

---

In the country dropdown, you should also see a preview of the date format. As far as I can tell, there isn't any that turns the month into a spelled out word.

If you want this behavior, this would require an Operation Hub Professional or Enterprise subscription where you can build a workflow with a custom code action that 'translates' the date into the format you'd like. Let me know if you have that subscription and I can assist with the custom code action.

Best regards

[JGrace8]

Thank you Karsten.

We don't have Operation Hub Professional or Enterprise subscription. However, for posterity, should the code be noted here to help others looking into this same issue?

I only see a list of countries under Settings > Account defaults > User defaults > Date and number format. It does not show any output samples at all. To me, this makes it very confusing.

It feels a little perplexing that HubSpot has no way to automatically insert dates into messages that would use a more 'human' way of saying them, using words.

Is it for-sure that there is absolutely no way to do this with the native features of HubSpot?

What if the dates were set up as properties, using 'text' and then inserted that way? 

Thank you again for your help.

[karstenkoehler · Accepted solution]

@JGrace8 could you please show a screenshot of the country dropdown?

I am not aware of any default settings that would format a date property in a way that returns the month as a word, correct. It can be done natively in HubSpot, requiring access to certain subscriptions however - alternatively through integrations like Zapier.

And yes, storing the spelled out date in a single line text property would of course work - but you won't be able to apply date filters to a single line text.

[karstenkoehler · Accepted solution]

Hi @JGrace8,

The date format for personalization tokens in emails is determined by the numbers format you choose for your account: Settings > Account defaults > User defaults > Date and number format

---

@JGrace8 wrote:

The "Date and number format" drop down shows a list of countries. I believe this is for determining if month or day should go first? If so, that is not what I'm trying to adjust.

---

In the country dropdown, you should also see a preview of the date format. As far as I can tell, there isn't any that turns the month into a spelled out word.

If you want this behavior, this would require an Operation Hub Professional or Enterprise subscription where you can build a workflow with a custom code action that 'translates' the date into the format you'd like. Let me know if you have that subscription and I can assist with the custom code action.

Best regards