to add 2 year simply:
expiration date = Date ( Month ( beginning date ) ; Day ( beginning date ) ; Year ( beginning date ) + 2 )
"And then, how to have an alarm if the expiration date is in the past ?"
There are more than a way to obtain this...
Do you wish a message, a change of the text color of the field or other ?
Thank You for your answer... it's ok.
I'd like the color of the text to change if possible.
the color of a date field can't be changed, nor we can use conditional formatting because you are on 8.5.
So create a new calculated ( UNSTORED ) text field with calc:
expiration date ≤ Get ( CurrentDate ) ; TextColor ( "n" ; RGB ( 255 ; 0 ; 0 ) )
format it with font: webdings size: 12
set the size of the field to 20x20px
place it near the field "expiration date"
make it NOT enterable in Browse mode.
The result will be a red ballon near the field if the Today date is past the expiration date.
This is exactly what I want to do, but I have put in the code shown, replacing 'expiration date' with a valid field name. (I have in fact clicked on the field name from the list shown)
When I click OK, it says Field Not Found, although I can see that the field exists and is in the list.
Any ideas as to what the problem may be?
Where is stopping the cursor inside that calc ( at the moment of the error ) ?
Have you correcty writed the n inside quotes ?
I copied and pasted the code, and the n was in side quotes.
The cursor highlighted the field name and said field not found. Although I selected the field from the list.
Try to write that calculation by hand ( not copy from this site and paste )
You are a star!!!
Typed it in by hand and it worked