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?