structure formula to convert duedate to timestamp

[mike]

In jira structure, doing a structure column formala with "DATETIME(duedate)" gives an error, only shows "VALUE!".

How do I get the timestamp value of duedate?

[Stepan Kholodov _Tempo_]

Hello @mike 

The datetime() function is used to covert text values into timestamps. The Due Date field already is a timestamp, so no conversion is needed. You can simply refer to it as duedate in the Formula, and set the format of the column to Date/Time. You can also change the Style in the configuration as well to display the time parameter as well. But please note - if you're using the default Due Date field, then it's the Date type of file, i.e. it doesn't have the time parameter by default. The Formula will return midnight for it for that reason.

And if your formula is more complex, and it's not possible to change the output's format, then you can display the date by using the format_datetime(dauedate, "dd-MMM-yyyy") function.

I hope this helps. If you need further assistance or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)