Hi

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

Try:

Max ( FieldA - 60 ; Get (CurrentDate) )

This looks like it should be done in an unstored calculation field - if you do it by script, then "today's date" will be the date on which the script ran.

I've not used the Max function a great deal, so I'd try comment's suggestion first, but this should work too:

Let(

D = FieldA - 60

;

If( D < Get( CurrentDate ) ; Get( CurrentDate ) ; D )

)