+ Start a Discussion
Jennifer LindseyJennifer Lindsey 

How can I pull the year from a date/time field and format in 4-digit YYYY without a comma?

Currently I can pull the year from a DateTime field with the "datevalue" conversion but it returns a number with a comma for a year (ie: 2,020 instead of 2020). Is there any way to pull the year from the DateTime field without a comma?
James (CloudAnswers)James (CloudAnswers)
If you're using a formula to retrieve this value, then you can just make the formula return text instead of a number.  This way your result is a clean "2020" and sorts/groups will still work but without any number formatting.