How can I shorten the date in the e-mail?

[Antonia]

So I have built a rule that sends me a reminder email and the rule should contain the date on which I have to renew a key. The date is in the asset. I have also already built a query that also gives me a date in the mail, but the date is displayed the wrong way round and with the time. Can I change this somehow? I have already tried every formatting but none of them work.

{{lookupObjects.first.DATUM}} --> 2025-07-29T00:00:00.0+0000

??? --> 29.07.2025

[Marc - Devoteam]

Hi @Antonia 

You could solve this by 1st creating a variable.

Then in the email use {{<variable-name>.toDate.jiraDate}}

Does this give you the required output?

[Kris Dewachter]

Hi @Antonia ,

You will have to convert your date to a "Date" format in order for the formatting to work.

Can you try

{{lookupObjects.first.toDate.format("dd/MM/yyyy")}}

Best regards,

Kris

[Antonia]

Hi @Kris Dewachter

thx for ur help!

I have tried it, but then no date is displayed in the mail. The attribute field is already in date format, so for the attribute you have to select the date from a calendar, it is not a text field.

[Kris Dewachter]

@Antonia ,

As @Marc - Devoteam mentioned, you will probably have to put it in an automation rule variable first, before you can use it in an email.

So put this value in a variable : 

{{lookupObjects.first.DATUM}}

And the in email you can use :

{{<variable-name>.toDate.format("dd/MM/yyyy")}}