3 Replies Latest reply on Jul 18, 2013 7:35 AM by Jonathan Drummey

    Percent of Day Function using now()

    Mark Schwager

      I have the following function that I am using to calculate the Percent of Day:


      Percent_Thru_Day = (datepart('hour',now())*3600+datepart('minute',now())*60+ datepart('second',now()))/86400


      The formula works perfectly.  However, the only way to continuously update the result of this function is by manually clicking "refresh", either with F5 on the desktop application or by clicking the refresh icon on the server.


      How can I get this function to auto-update with the time as time changes?


      Scheduled extracts do not work.  Only the manual click.  Help!