Hi All

I need to highlight the same field different colours based on a date.

If 'Date Required' is less than 7 days from todays date I need 'Request No.' highlighted red. I've done this using the format editor.

If 'Date Required' is between 8 & 14 days from todays date I need 'Request No.' highlighted orange. This I'm having problems with.

Details {req_no} {title} {date_req} {date_raised}

I know I need to write a formula to find the 'date raised' is between 8 and 14 days previous to current date, but I can't.

I hope I've included enough info.

Thanks in advance for your help.