Use this calculation for the conditional formatting option of the field "next_date":
Self ≤ Get ( CurrentDate )
and set the field's background color to red
Thank you for your reply
Do you want to say, that i should use a relation, so the field only appears when its out of date?
The next_date has already a calculation next_date= (chat_date +186)
I've tried with a calculation, but then the background is always red.
While in Layout mode, select that calculation field and:
Format >> Conditional... >> Add >>
1) Formula is: Self ≤ Get ( CurrentDate )
2) check the box "Fill Color"
3) Choose the red color
Well that was way too EASY, great
thank you for your help