How to diff of two Date& Time fields using FAFR

How to diff of two Date& Time fields using FAFR

If you have two date and time additional fields or default fields, and if you want to capture the difference between those two fields in Hours and minutes, then use the below script to capture the value in an additional field,

Under the respective Incident/Change template FAFR,provide the necesary criteria and  under Actions, select Execute script and provide the below script,

var x=$CS.getValue("WorkOrder_Fields_UDF_DATE1");

var y=$CS.getValue("WorkOrder_Fields_UDF_DATE2");

var z=y-x;

var a=z / (60 * 60 * 1000);

var b=z / (60 * 1000) % 60;

var c=parseInt(a)+" hours"+parseInt(b)+" minutes";

$CS.setValue("WorkOrder_Fields_UDF_CHAR1",c); ( Here Workorder_Fields_UDF_CHAR1 is the custom field which shows the Hours and minutes).


The above script if you input two Date and Time values, then the output will display in the below format,



                    New to ADSelfService Plus?

                      • Related Articles

                      • Script to Populate User Additional Field under Incident Template using FAFR

                        The script load the Requester Name under Incident Additional field ( As a pick list), by choosing the requester name under additional field the script populates the user additional field value. * Kindly create two additional fields under Admin -> ...
                      • FAFR - Sample script to have the additional field value appended to the actual subject line

                        Here is a sample script to be used in FAFR to have the additional field info appended to the actual subject line, var contract=$CS.getValue("WorkOrder_Fields_UDF_CHAR5"); var subject=$CS.getValue("SUBJECT"); var new_subject = subject + " : " + ...
                      • Script to set fields from CSV using FAFR.

                        Works in 10604 Requirement: Load Data from CSV depending on the value selected in an additional field. Usecase: Assume there are 3 additional fields for a request template, namely, "Reference number", "Payment type and "Vendor". "Reference number" is ...
                      • How to disable the Created Date field for technicians

                        1. Roles Under Admin >> Roles >> Disable the below access The above option will disable the user from modifying Created Date, Resolved Date, Dueby Time. 2. Field and Form Rules If the requirement is to disable only Created Date field.  Under Admin >> ...
                      • Script to find the actual SLA of an Incident

                        Use case When an incident is logged, the timer for the SLA is started. However, the actual incident might have occurred hours before the incident creation. In order to find the actual time of SLA,  we can use a python script.  Pre-requisite  Python ...