- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-19-2020 09:39 AM
Thank you so much!
Everything is working exactly as I was hoping for now.
Red, Yellow and Green dots are showing up on Task View and problem view with corresponding due dates.
Here's what my 3 styles finally look like now:
Table: Task
Field Name: Due Date
Value: javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task' && current.state < '3' ; answer;
background-color: red
Table: Task
Field Name: Due Date
Value: javascript: var answer = (current.due_date.getDisplayValue() > (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task' && current.state < '3' ; answer;
background-color: yellow
Table: Task
Field Name: Due Date
javascript: var gdt = new GlideDateTime(); gdt.addDays(7); var answer = (current.due_date.getDisplayValue() > gdt.getDisplayValueInternal()) && current.sys_class_name == 'problem_task' && current.state < '3' ; answer;
background-color: green
Couldn't use your suggest value for "yellow" since it was too long to fit into the window.
But my three styles seem to be evaluated correctly anyway.
Thanks again