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