Joined: 18 Jul 2011
Location: United States
Online Status: Offline
Posts: 11
Topic: What is wrong with my formula Posted: 08 Mar 2013 at 11:07am
I am trying to create a formula that will look at a parameter DateTime and determine if it is greater than the DateTime in a field. If it is greater then the result is the parameter time, if not the result is the field time. This is what I have
timeVar x := (Time({Command.SCAN_CREATE_TM})); timeVar xx; IIF (x>Time({?End Time}),xx:=Time({?End Time}),xx:=x)
The result ends up being everything becomes the parameter time. What is wrong? Thanks.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum