Format Date in Text Mode | Community
Skip to main content
P
PujaPa
October 4, 2018
Question

Format Date in Text Mode

  • October 4, 2018
  • 2 replies
  • 669 views
Hi Everyone, I tried to search for an answer to this before posting but I was unable to find something that matches. I am modifying a report and I want to display only Year of Project Start Date instead of the entire Project Start Date. So if start date is 2/1/2018, I would like for it to only display 2018. I tried the following based on what I have read so far but was unsuccessful in my attempt. Thank you in advance for your help! displayname= linkedname=direct namekey=actualStartDate querysort=actualStartDate textmode=true valueexpression=YEAR({actualStartDate}) valueformat=atDate Puja Patel
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor
Community Advisor
October 4, 2018
Hi Puja, I suspect your valueformat=atDate is defeating your valueexpression, and instead, suggest you either remove that line, or try valueformat=HTML Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads
P
PujaPaAuthor
October 5, 2018
You, my friend, are the real MVP. That worked like a charm. Thank you very much for your help! Puja Patel Enabling Solutions
Terms & ConditionsAccessibility statement

Loading footer...