2 Replies Latest reply on Feb 11, 2013 11:46 AM by Jonathan Drummey

    Now() function error

    Robert Hughes

      I'm attempting to generate pseudo-pseudo-random numbers; I was planning on using something involving Now() in order to generate a lousy approximation.

       

      In a calculated field, I'm running the following:

       

      DATEDIFF("second",#Jan 3,2012#,NOW())

       

      ...to which I'd apply some sort of post-processing.  When I do this, however, I get the following on a dashboard update:

       

      Internal Expression Error: Function 'NOW' is not defined in the current context.

       

      Any thoughts?