Column that displays date report was run? | Community
Skip to main content
Christina_Jarosz
Christina_Jarosz
Level 9
December 1, 2022
Solved

Column that displays date report was run?

  • December 1, 2022
  • 1 reply
  • 1058 views

Is there a way to add in a column to any report of (right now) so that when we create a report and export it, it shows the date in a column?

i.e. I want to be able to see what you'd see in the title of a file, so when I'm looking in an excel document I can know when the report was run/exported.

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 Doug_Den_Hoed_AtAppStore

Ah ok, I see what you're looking for. I don't know how to do that straight from Workfront. I wonder if maybe @doug_den_hoed__atappstore has an idea that would work for you - any thoughts, Doug?


 

Thanks for the tag (and the challenge) @sheri_whitten: yes, I did figure out a solution.

 

@christina_jarosz, to make a view include the current date and time (for exporting purposes), I invite you to add a column with the following text mode:

 

valueexpression=$$NOW valueformat=fullAtDate displayname=Current Date And Time

 

Which will then look like this:

 

 

Regards,

Doug

 

cc: note to self @doug_den_hoed__atappstore 

 

1 reply

S
Community Advisor
Sheri_WhittenCommunity Advisor
Community Advisor
December 5, 2022

We use the Last Viewed By: Name and the Last Viewed Date - these are native fields in the Report report type. Is that what you're looking for?

Christina_Jarosz
Christina_JaroszAuthor
Level 9
December 6, 2022

Thanks Sheri! I'm looking to display the time/date stamp of the current minute.

 

I want to be able to see, on an excel in a column, this report was exported on xyz date at xyz time.

 

The reports may have been viewed/edited etc multiple times. But if I am running multiple reports, I want to know that 'this data was pulled on Monday, 12/06 or Thursday, 12/01 for example. 

S
Community Advisor
Sheri_WhittenCommunity Advisor
Community Advisor
December 7, 2022

Ah ok, I see what you're looking for. I don't know how to do that straight from Workfront. I wonder if maybe @doug_den_hoed__atappstore has an idea that would work for you - any thoughts, Doug?

Terms & ConditionsAccessibility statement

Loading footer...