Return to FileMaker.com
Calculating with a date field
I need the following and I think I can do it in a calculation field, but have also thought of a script.
Field A is a date field. I want field B to contain the date of field A minus 60 days. But if the new date is less than today's date then it should display today's date.
Can anyone help me with constructing fiels B?
Kind regards, Mille
B = calculation field to result in date
If ( (FieldA-60) < Get (CurrentDate) ; Get(CurrentDate) ; (FieldA - 60) )
...the Case function would do much the same thing in this case.
Retrieving data ...