Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!
SOLVED

Unix Timestamp Conversion

Avatar

Level 2

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

ElanR1_0-1691293219754.png

 

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

 

ElanR1_1-1691294459902.png

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

 

ElanR1_2-1691294521663.png

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 6

Also, use X as the format specifier:

 

formatDate( {{now}} ; X )

 

for example.

View solution in original post

4 Replies

Avatar

Level 6

formatDate({{timestamp}};X)

parseDate({{timestamp}};X)

Avatar

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. 

ElanR1_0-1691411008836.png
Still I am getting the below error.

ElanR1_1-1691411072591.png

 

 

Avatar

Level 6

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

Avatar

Correct answer by
Level 6

Also, use X as the format specifier:

 

formatDate( {{now}} ; X )

 

for example.