Set Field [YourTable::RecallDate; 1stField + 180]
If RecallDate = Get(Today)
Make RecallNotice Field Big and Red
Meaning add 180 days to the LastApptField and set RecallDate to that date.
If the RecallDate equals Today
Set the notice field (a calculation) to a noticiable color or font or icon
If you want to see a date for the same day, but 6 Months in the future, you could also use:
Date ( YourDateField) + 6; Day(YourDateField); Year(YourDateField) )
I'd put this expression in a calculation field set to return a date type so that you don't have to script the update. Instead, it'll compute the desired value automatically after you enter a date in "YourDateField".
In addition to conditional formatting, you can also choose to write a script that searches for recall dates. You can then use File Options to run this search each time you open the file.
Missing the Month ().
Date ( Month ( YourDateField) + 6; Day(YourDateField); Year(YourDateField) )