AnsweredAssumed Answered

My script based on dates isn't working

Question asked by davidtspf on Apr 5, 2018
Latest reply on Apr 5, 2018 by davidtspf
  • Comment • 7

I'm building an app for a medical clinic. I want to note that a patient had an X-ray done in his Medical History table. But my script on the button that transports the user from the X-ray Results page to Medical History table isn't working:

 

If [Tests::Xray date > 12/1/2000]
   Set Field [Medical record::Xray; "Yes"]
End If

 

I'm not sure if it's failing because the date is the wrong test. Or because "Yes" is the wrong value to set the field to (it was a checkbox labeled "Yes", and then I made it a field where a user could type "Yes").

rgordon
rgordon Apr 5, 2018 1:28 PM
Correct Answer

Are you running the script from a layout that can see the Tests::Xray date?  Is Tests::Xray date on the layout.  If not place it on the layout to see if it is working properly.  I'm guessing you might have a relationship problem.

See the reply in context
No one else had this question

Outcomes