Capture Order Date\Time

[cothmer]

I am trying to capture an order date\time for patients. The patients may have multiple orders, I only want to capture a particular order and the date\time. Below is my formula that I am putting in my main report, it doesn't give me the correct order date\time. I can get this to work using a sub-report but I don't really want to use that. I wasn't sure what else to use besides an if, then, else statement. This statement requires a date\time for the else function so I had use some sort of date\time field.

[former_member292966 · Accepted solution]

Hi Curt,

If you want the Else to return nothing, you can exclude it from your formula or pass a NULL date like:

if {CLARITY_EAP.PROC_CODE = 'ADT8' Then {ORDER_PROC.ORDER_TIME} 
else DateTime(0, 0, 0, 0, 0, 0)

The Else should return a NULL DateTime for you.

Good luck,

Brian