Confiforms sends email with incorrect date format

Soley Gudmundsdottir

Confuence v. 7.13.0 and Confiforms v. 2.19.2

My form sends an email at entry creation using IFTTT integration rules. The date is from a datepicker field but using the notation [entry.date] it transforms the date to a string?1631577600000 when sending an email with the entries in the bodu of the message. Using the macro to create Jira issue, correctly sends the date to Jira.

The form has been in use for 2 years and this worked fine during that time, but after a recent update, both Confluence and Confiforms, that changed.

Could you please advise on how to get the date in a correct format via email as well?

 

Alex Medved _ConfiForms_

Hi

Are you using [entry.field_name] notation to retrieve your data field from the form's record or using ConfiForms Field?

If  (form some reason) you use [entry.field_name] then you access internal value, which is a timestamp

In this case I suggest to do something like

[entry.field_name.formatDate]

Of course you can format it to the pattern you want

https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

Or switch to ConfiForms Field macro to retrieve values from a form in a "user presentable" format

[entry.field_name] are usually used when you want to do some transformations or create some file/document, or use it in filter parameters...

Alex