Date/Time: Detecting Year as Date/Time w/o thousand separators?

chrisamott · April 23, 2010 2:24PM

When using the DATEUNIT function to determine the year of a date, by default the result is displayed as an Integer number with thousand separators. Using Data > Manage Fields, we can reformat to remove the separators if we needed a plain integer displayed.

However, when using DATEUNIT as part of a larger function, to create a string YEAR + "Quarter 2" for example, the thousand separator cannot be so removed and the result, '2,009 Quarter 2' is far less preferable than '2009 Quarter 2'.

Can this be resolved?

steve · April 23, 2010 3:39PM

Try this:
TEXTVALUE(YEAR, "#") + "Quarter 2"

chrisamott · April 23, 2010 3:49PM

Yep, that's got it. I incorporated the DATEUNIT funtion into the YEAR part of the TEXTVALUE funtion you refer to and it works a treat.

Thanks

chrisamott · August 5, 2014 7:21AM

How may I format the date unit as day of the week. Mon, Tue, Wed etc

paola · August 5, 2014 7:29AM

EEE is the shortened 3 character day format (EEEE would display full day name e.g. "Monday").
You can find the full list of date formats on this page:
http://www.visokio.com/dates-and-times

Welcome!

Categories

Ideas Parade

Tagged