inserting date into email template

[vikram-mit]

i have email template for our lead follow up emails where we usually suggest a date 2 business days of sending the email. currently, it is a pain to manually update the date every time we send email. is there a way to insert it dynamically the way we can do the personalization attributes?

[Glay_Imutan]

Hello Alyssa,

Is there a way how to change the format of personalization tokens? For example, instead of 7/14/2022, the output will be Jul 14, 2022.

 
Here's what it looks like from the source code:

Thank you in advance.

[alyssamwilie]

@Glay_Imutan I believe using the filter instead of the function is better suited for personalization tokens:

{{ company.subscription_end_date|datetimeformat('%b %e, %Y') }}

[Glay_Imutan]

That was fast! Thanks Alyssa. I tried the script above however I think I missed something? 

Here's what it looks like from the source code:

 

It doesn't reflect the date as it should be. It appears blank on the "preview" mode:

What could be the problem? 

[alyssamwilie]

@Glay_Imutan Sorry, I completely missed that this post was about email. Unfortantely, Hubspot does not support formatting on contact properties in email. 😔

As stated in their documentation :
"Please note that using filters on any personalization variables (such as but not limited to contacts, company, and deal variables) is not currently supported for email in HubSpot due to how emails are rendered"

[Glay_Imutan]

Oh no worries! thanks for checking and for helping me. Greatly appreciate your effort 😃

I'll just use zapier to do the format. 

[CCassidy]

This is great!!

I've been looking through HubL, some really good stuff. 

One more additional question on this one.

in a workflow within an email can I set the date as 'end of the month' for example: Available until the end of May

So then June arrives and it will prepopulate to now be Available until the end of June.

Thank you in advance.

[alyssamwilie]

@CCassidy You can grab the current month like so :

{{ datetimeformat(local_dt, '%B') }} 

So at the time of me posting this that code would output "May" then on June 1st it'll start outputting "June".

[alyssamwilie]

@vikram-mit 

You don't need a personalization token or workflow. You just need one little line of HubL -

{{ datetimeformat(local_dt, '%B %e, %Y') }}

You can hardcode it into a module or you can even paste it into the HTML of a richtext module. Note: if placed in a richtext module it'll show as code in the page editor, but the date will be rendered in preview and on send). Ex:

Page Editor (Do not type directly into the rich text, open the source code)

Preview

[kaitlynwells]

Found this while looking for a way to insert a dynamic date into an automatic email, this worked perfectly - thank you! 

[Rob_Gordon]

Did you manage to insert this into a template? For a 1:1 email? Or only in a Marketing email?

Thanks
Rob

[LoraBergeron]

Hi,

I need to add a variable date as well, but I'd like to add, for example, 21 days after the current date. I'm using this to communicate an expiration date that changes with an email send from a workflow.  It can't link to the content.update information.  It needs to link to whatever date the email is sent out.  Can you help me?

Thanks in advance,

Lora B

[kamlesh_k]

There is no token that you can use that inserts the date.

One thing you could try is a workflow to manage the email send. If you use a workflow then you can have a field with the date that triggers the email then you can use a personalization token for a date field.

[fdasilva]

Can we please get on creating such an option. Competitors like Salesloft and others have had this implemented for years.