Color scheduled report pdf column

[Aryan]

Hi All,

We have a requirement where we have to color code the planned start date column as red if the planned start date is passed form the current date and time.

OOTB I see the conflict tab and Priority tab is showing red and green color highlighted in the scheduled report (pdf)

[Aryan]

[Dr Atul G- LNG]

Hi @Aryan 

My PDF Report

; (semi colon ) missing after orange.

and it will show color where plan end date = empty.

[Aryan]

Thank you @Dr Atul G- LNG for your help now we are able to see the color in my pdf report.

We have also tried the below script include to filter all the change request where planned end date is passed as per the current date. 

But it is not working can you also help us on this?

 checkDate: function() {

        var gr = new GlideRecord('change_request');

        var currentTime = new GlideDateTime();

        var oldTime = new GlideDateTime(gr.end_date);

        if (currentTime > oldTime) {

            return true;

        }

[Dr Atul G- LNG]

Sorry my friend, I am not good in coding

My friends @Sandeep Rajput @Community Alums can help here. 

[Aryan]

No worries, I got it Thank you for your help!!