I have a date range field that is ran from a parameter field. Is there anyway to turn the date (promise date) red if it is past today’s date? This is my field that is being used to pull data.
Cdate({Projections_WIP.PROMISE_DATE})
{Projections_WIP.PROMISE_DATE} = {?Date}
Thank you in advance
Melmaser72 (BOB member since 2018-09-19)
I am assuming that you want to field to be red when being displayed in the report, not in the record selection.
If so, right click on the field in the report click on the x-2 (formula workshop) for either the font color, or background color and have something like this.
if {promise date} is > current date then crRed else crNoColor
kevlray 
(BOB member since 2010-06-23)