Changing Field Style for Problem Tasks if due date is passed

Joe Taylor
Giga Guru

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.) ?

 

 

1 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)
find_real_file.png

 

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

 

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

View solution in original post

22 REPLIES 22

Ashok Katam
Mega Guru

Hi Joe

 

Can you try changing value to this format. Please ignore if you already tried it

 

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

 

Thanks

Joe Taylor
Giga Guru

Thanks for the suggestion.  This didn't work either.  I think my issue is more fundamental.  I tried just changing the value to just "true" to see if my style rule was even getting applied.  This didn't work either.  So I must be missing something basic to make the style rules active or something.

Use this Value-

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

 

I tested it works.

I usually check all exisiting style shees for reference and some you need to try if not already used in system.

 

-Tanaji

Please mark response correct/helpful if applicable

I want to color coding on due date , this field is from task table , my table is extended from task table , so I am using due date on workspace in simple list component , I want color coding for my workspace, yellow color if 50% of days are left , 25% of days left than orange, and days completed than red in ServiceNow . Is it possible?