Show entry date as HH:MM:SS format in report

Forum|Forum|2 years ago
August 9, 2023
2 replies
896 views

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?

@csatscale

Workfront

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 lgaertner

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

lgaertner

Level 9

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

lgaertnerAccepted solution

Level 9

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

S

shirinshaikhAuthor

Level 2

Thank you @lgaertner @nicholevargas Thank you for your inputs. I will try the calculated expression once 🙂

NicholeVargas

Adobe Employee

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:

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded