Conditional Highlight for Dates

Hi all

I am trying to do a report for Personnel Authorisations, where authorisations that have expired (i.e. in the past) are highlighted in red font and those that are in the future are left black.

I've tried a variety of code such as: -

Value < [DATE]

Convert.ToDateTime(Value) < [Date]

I've also tried DateTime.Parse()

All of them throw an error such as that shown in the attached image.


Can someone help please?

Thanks


Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.