Tagged with texttodate - Visokio Forums http://forums.visokio.com/discussions/tagged/texttodate/feed.rss Mon, 30 Oct 17 15:43:56 -0400 Tagged with texttodate - Visokio Forums en-CA Comparing Date values: Filtering dates after 2014 http://forums.visokio.com/discussion/3160/comparing-date-values-filtering-dates-after-2014 Wed, 03 Aug 2016 05:54:58 -0400 Phillipa 3160@/discussions
I am totally new to dates in Omniscope and would like to know how to select dates post 2014.

I have a field in date format dd.MM.yyyy HH:mm:ss and want to select records that are only after 2014.

I know it is not rocket science but as a beginner I need some help.

Thanks.
Phillipa]]> 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?]]> Date/Time: inconsistent formats in a Date field http://forums.visokio.com/discussion/2611/datetime-inconsistent-formats-in-a-date-field Mon, 23 Jun 2014 12:57:31 -0400 paola 2611@/discussions
image
Another useful example :
4/18/2015 1:31:09.000000 AM
translates into Omniscope format
M/d/yyyy h:mm:ss.SSS a]]> Formulae: Entering literal Date/Time values in formulae http://forums.visokio.com/discussion/2289/formulae-entering-literal-datetime-values-in-formulae Wed, 14 Aug 2013 14:38:32 -0400 tjbate 2289@/discussions and the Date/Time formatting mask characters specifying the exact Date/Time format the literal value will be compared with inside single or double quotes:

image]]> 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]]> Date/Time: Parsing incoming Text with no year? http://forums.visokio.com/discussion/1664/datetime-parsing-incoming-text-with-no-years Fri, 20 Jul 2012 11:42:46 -0400 sherriff 1664@/discussions
Reading in a .txt file with comma separators, I get a Text field with date/time formatted as follows:

Tue 19 Jun 19:33

I am trying to format this into a recognised Date/time field using the Date format (input):
EEE dd MMM HH:mm
but I see no output? What am I doing wrong?]]>