Tagged with dateunit - Visokio Forums http://forums.visokio.com/discussions/tagged/dateunit/feed.rss Mon, 30 Oct 17 18:20:22 -0400 Tagged with dateunit - Visokio Forums en-CA Date/Time: Detecting Year as Date/Time w/o thousand separators? http://forums.visokio.com/discussion/295/datetime-detecting-year-as-datetime-wo-thousand-separatorss Fri, 23 Apr 2010 14:24:48 -0400 chrisamott 295@/discussions
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?]]> Formulae: Bucketing time values? http://forums.visokio.com/discussion/1951/formulae-bucketing-time-valuess Fri, 14 Dec 2012 15:30:49 -0500 DanVatcu 1951@/discussions
Based on the TIME field , I need a formula to convert it into a new text field (let's call it TIME_OF_THE_DAY) as follows:

If TIME is between 00:00:00 and 06:59:59 then TIME_OF_THE_DAY field value should be 'night'
If TIME is between 07:00:00 and 11:59:59 then TIME_OF_THE_DAY field value should be 'morning'
If TIME is between 12:00:00 and 17:59:59 then TIME_OF_THE_DAY field value should be 'afternoon'
If TIME is between 18:00:00 and 23:59:59 then TIME_OF_THE_DAY field value should be 'evening'

How can I do it? Can you suggest a script?
Thanks]]>