Unix Timestamp Conversion

Hi Team, I have a date picker field to choose due date in project custom form.

In fusion scenario, I am using timestamp to convert the "due date" to unix,

Its throwing me the following error, Please help me converting date unix format.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by cverges

Divide your time stamp by 1000 first. You have a millisecond time stamp; Workfront only supports second precision.

Also, use X as the format specifier:

formatDate( {{now}} ; X )

for example.

Level 5

formatDate({{timestamp}};X)

parseDate({{timestamp}};X)

Level 2

Thanks for the reply. Its not working for me, please guide me to get the output in following format - 1691769915000

Please note that "DE:Due On" is getting the value from date picker field in custom form.

This is how I set as per your suggestion.

Still I am getting the below error.

cvergesAccepted solution

Level 5

Divide your time stamp by 1000 first. You have a millisecond time stamp; Workfront only supports second precision.

Also, use X as the format specifier:

formatDate( {{now}} ; X )

for example.

Sign up