Thanks in advance for any advice. I searched the forums, but I may not have been using the right keywords.

 

I am using this formula to get to turn around time (in seconds) for a work item in our database:

Datediff ("s", {wf_job_events.event_date}, {@CompleteDate})

 

The @CompleteDate formula is:

If IsNull ({work_items.completion_date}) THEN
CurrentDateTime
Else {work_items.completion_date}

 

The business requirement is that we still need to generate a turnaround time for work items that are not complete yet (I end up higlighting the records in red to indicate that the item is still open).

 

Now this works great, unless the workitem is not yet completed.  The formula will generate a date, but CurrentDateTime is based on the PC time, and the time date stamp on the work item is based on GMT.

 

How do I make this formula evaluate CurrentDateTime at the server level?

Or another way to do it is to ask: Can I change CurrentDateTime to be GMT instead?