Calculating with a date field

[mille]

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

[comment]

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.

[PotzUK]

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 )

)