Tagged with date-time-formulae - Visokio Forums http://forums.visokio.com/discussions/tagged/date-time-formulae/feed.rss Mon, 30 Oct 17 15:48:09 -0400 Tagged with date-time-formulae - Visokio Forums en-CA Time Series Growth Calculation - Getting Incremental Numbers from Cumulative Total http://forums.visokio.com/discussion/3127/time-series-growth-calculation-getting-incremental-numbers-from-cumulative-total Thu, 12 May 2016 17:53:16 -0400 MPatel 3127@/discussions I have data that's coming in cumulatively:

Date | # of Participants
4/1/2016 | 400
4/2/2016 | 500
4/3/2016 | 625

I want a field that will calculate the difference from the day before. So for 4/2/2016, it would show 100 (500-400). For 4/3/2016 it would show 125 (625-500). Please let me know what formula to use. Thanks!]]> 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]]>