Hello everyone,
When we export reports in Excel, the entry date values show format as date HH:MM:SS AM/PM format. However, the seconds do not show in the report columns in Workfront. Can someone help with the syntax to show the entire timestamp for the date field?
Solved! Go to Solution.
Views
Replies
Total Likes
You don't really need the diversions via a calcualted field, as you can add a column with the following text mode:
valueexpression=CONCAT({lastLoginDate}, ' ', HOUR({lastLoginDate}), ':', MINUTE({lastLoginDate}), ':', SECOND({lastLoginDate}))
valueformat=HTML
Hi,
good question, but I did not find any possibilty to directly format a date to show seconds also.
As a workaround, you could create a calculated field with the following "calculation"
CONCAT({lastLoginDate}, ' ', HOUR({lastLoginDate}), ':', MINUTE({lastLoginDate}), ':', SECOND({lastLoginDate}))
Regards
Lars
Views
Replies
Total Likes
You don't really need the diversions via a calcualted field, as you can add a column with the following text mode:
valueexpression=CONCAT({lastLoginDate}, ' ', HOUR({lastLoginDate}), ':', MINUTE({lastLoginDate}), ':', SECOND({lastLoginDate}))
valueformat=HTML
Thank you @lgaertner @NicholeVargas Thank you for your inputs. I will try the calculated expression once
Views
Replies
Total Likes
You cannot format dates in Workfront to have seconds, unless you create a custom text mode expression (like @lgaertner shared) so that would be your best bet. This article shares are all the different date formats that Workfront can display:
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies