Has anyone had any luck on being able to drive Color Options for Start Center Portlets based on the current date in relationship to a Work Order field date.
I'm trying to compare the Work Orders Status Date to the Current Date, and I am able to due this using
:&datetime& in the expression field for the color options. This works for simple comparison of the Status Date to the Current Date. I'm looking to figure out how write the statement so that if the Work Orders status date is more that 14 days ago when compared to the System date, the row would be red. I've tried a few ways but with no luck, any advice would be great.
Works without ability to adjust days ahead/before
Does Not Work
Thanks,