Hi,
I want a cell in a form to be highlighted when a unit is out of warrantee. At the moment we will deliver a unit on site and then from that date we count 18months for warrantee period. So I have two cells, one called warrantee end date and delivery date. If the 18 months has come to pass the warrantee end date must change to red for instance, because the unit is now out of warrantee. Can someone please help me
I did try the below, but can not get it to work:
> DateAdd("m";18; "= [DeliveryDate]" )
I want a cell in a form to be highlighted when a unit is out of warrantee. At the moment we will deliver a unit on site and then from that date we count 18months for warrantee period. So I have two cells, one called warrantee end date and delivery date. If the 18 months has come to pass the warrantee end date must change to red for instance, because the unit is now out of warrantee. Can someone please help me
I did try the below, but can not get it to work:
> DateAdd("m";18; "= [DeliveryDate]" )