Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
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.