Changing Field Style for Problem Tasks if due date is passed

[Joe Taylor]

I'm trying to change the font color of the due dates in the list view of PTASKS if the due date is past, but no matter what I try it doesn't seem to work.

Here's what I have now:

Table: Problem Task [problem_task]

Field Name: Due date

Value: javascript:gs.dateDiff(current.due_date.getDisplayValue(),gs.nowDateTime(),true) <  0 ;

Style:  color:red;

What am I doing wrong?

Also, where can if find a comprehensive list of styles  (colors, background, font sizes, etc.) ?

[Joe Taylor]

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

[Tanaji Patil · Accepted solution]

If its exceeding the field limits then you can put the code in script include and from there return true/false.

Like for yellow you could do this.

1) Create a script include (I named mine as TestDate)

2) Then call the script include (and function - which I named isYellow) from Styles

Could you please mark my answer as correct? It gives me few points on community.

Thank you!

-Tanaji

Please mark reply correct/helpful if applicable

[lasse3]

It is highly recommended not to use display values, when doing scripting as this may give you unexpected results depending on display settings which may vary depending on customer regional settings etc. Instead use compareTo or numeric values when comparing dates. Here is an example:

javascript: var answer = ((new GlideDateTime(current.due_date)).getNumericValue() <= (new GlideDateTime().getNumericValue())); answer;

I hope this will help someone out there 🙂