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?