Condition for 60 day date validation

[miro2]

Hi,

I have to create a condition to meet the below requirement:
Date of today is greater than Date of field 'Sent for Approval' + 60 days. The Date of field 'Sent for Approval' is a variable and I was able to add its value in the Dashboard using database view. I want to check which condition will be better: 

javascript:gs.daysAgoStart(60)

or '60@days@ago'?

The value field is the date of the field 'Sent for Approval'

or

[Dr Atul G- LNG · Accepted solution]

Hi @miro2 

That’s a challenge. You need to store this in a proper date format first; then you can compare it. Otherwise, there’s no easy or direct way to do it. A date can be compared to another date, but a date versus a string cannot.

[Ankur Bawiskar]

@miro2 

the latest approach of using client callable script include worked fine for me

Please use that and let me know the feedback

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[miro2]

Hi @Ankur Bawiskar 
my script include works fine. I've checked it in a background script and it returns 1 record as expected. But when I try to call it in a condition, it doesn't work.

var GetMyRecordsScriptInclude = Class.create();
GetMyRecordsScriptInclude.prototype = {
    initialize: function() {},

    getMyRecords: function() {
        var resultArray = [];
        var gr = new GlideRecord('<my_database_view>');
        gr.addQuery('payroll_state', '18'); //WIP state
        gr.query();
        
        var today = new GlideDateTime();
        
        while (gr.next()) {
            var dateString = gr.getValue('qa_value');
            if (!dateString) {
                continue;
            }
            
            var recordDate = new GlideDateTime(dateString);
            recordDate.addDaysUTC(60);
            
            if (today.after(recordDate)) {
                resultArray.push(gr.getValue('payroll_sys_id'));
            }
        }
        return resultArray.join(',');
    },

    type: 'GetMyRecordsScriptInclude'
};

Database view-> the same result

[miro2]

Hi @Ankur Bawiskar 
regarding above solution about classless and client-callable script includes, I found that ServiceNow docs state that it can never be used client-side, even if the client callable option is selected.

Could you please share the steps you followed to fetch records using javascript:getMyRecord() in a condition?
Could the fact that this SI/database view is in a scoped application be the reason why the condition returns null?

Thank you