AnsweredAssumed Answered

Trying to create a field with an automatic value

Question asked by jessehidalgo on Jan 3, 2018
Latest reply on Jan 3, 2018 by jessehidalgo

I am trying to place text in a field depending on a creation date of a Patient record in an Invoice record.  I would like to search the creation date of the Patient Record and if less than 45 days have it input "New" and older than 45 days input "Existing" in the field of the Invoice record.  I have created a field with a calculation as follows:


If ( Patients::TSCreated - 45 ; "New" ; "Existing" )


It returns the same text no matter if the record is newer or older than 45 days.  Help?