I have a report which has a field where I can put any kind of text to suit deadlines. I'll put "DUE [DATE] [some other text]" if something needs to be done, and just "[DATE] [Completers Initials] [different sort of text]" when it is complete. The text components mentioned above can be any string for my notes.
I would like to add conditional formatting to this field as follows:
If the field contains "DUE [Today's Date]", highlight it red and bold.
If the field contains "DUE [Before Today's date]", highlight it pink.
If the field contains "DUE [Within 7 days of todays date]", highlight it yellow.
If the field contains "DUE [Beyond 7 days from todays date]", highlight it green.
I have this conditional formatting setup for a strictly date formatted field, but not a field that could have any string of text.
I'm really just having trouble getting the date part setup in the expression. Tried object indicator ("&"?) and got an error of some sort.
Thank you in advance.