You need to sign in to do that
Don't have an account?
Jennifer 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)
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.