Show only Month and Year from a custom date field | Community
Skip to main content
J
JulieVa
August 25, 2017
Question

Show only Month and Year from a custom date field

  • August 25, 2017
  • 3 replies
  • 807 views
I have a custom date field and only want to show the Month and Year on the report --- I used the following valueformat=customDateAsMonthString but does not work. Is this possible? Thanks! Julie Vargo The Ohio State University
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

P
PollyCo
Level 9
August 25, 2017
I would just reformat the date to get month and year. valueexpression=CONCAT(MONTH({DE:date}),YEAR({DE:date})) valueformat=HTML Polly Co
Kelly_Wehrmann
Kelly_Wehrmann
Level 9
August 25, 2017
You will have to reformat it. The following is the text mode code that I use in my Hours report to format the Hour:Entry Date field to appear as MM-CCYY. You can change the expression to format the date to suite your needs. displayname=Hour Month/Year linkedname=direct namekey=entryDate querysort=entryDate textmode=true valueexpression=CONCAT(MONTH({entryDate}),"-",YEAR({entryDate})) valueformat=HTML Admin Kelly-Wehrmann SSFCU
    J
    JulieVaAuthor
    August 25, 2017
    Thank you it worked! Julie Vargo The Ohio State University
    Terms & ConditionsAccessibility statement

    Loading footer...