How to find the date difference via client script in agent workspace

roshini1
Kilo Guru

I am having two fields start date and end date in my form and am trying to check whether the end date is less than start date, if yes it should throw and error. The script that i wrote is working in native view, but not in agent workspace.
Can someone help me out

var start_date = g_form.getValue("u_outage_start_date");
var end_date = g_form.getValue("u_outage_end_date");
var format = g_user_date_time_format;
var isEndBeforeStart = compareDates(start_date, format, end_date, format);
if (isEndBeforeStart){
g_form.clearValue("u_outage_end_date");
g_form.showFieldMsg("u_outage_end_date", "Outage End Date should be after Outage Start Date", "error");
}

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

g_user_date_time_format seems not allowed in workspace

you can use GlideAjax

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

10 REPLIES 10

sanh
Tera Contributor

Hi Roshini,

I tried in my developer instance, format is not working in agent workspace. try like this

 

var start_date = g_form.getValue("u_outage_start_date");
var end_date = g_form.getValue("u_outage_end_date");

if (end_date < start_date) {
g_form.showFieldMsg("u_outage_end_date", "Outage End Date should be after Outage Start Date", "error");
}

 

This is not working as expected..i mean if am selecting start date as 24th april and then giving end date as 3rd may it is giving error message. 
it's just calculating the date and not checking for month

Mahak2
Kilo Guru

Hello Roshini,

 

Can you please try below code:

 

var dateFormat=g_user_date_time_format;

 

var D_one = g_form.getValue("<first date>");

 

var D_two = g_form.getValue("<second date>");

 

var dateOneFormat = getDateFromFormat(D_one , g_user_date_time_format);

 

var dateTwoFormat = getDateFromFormat(D_two , g_user_date_time_format);

 

var difference=(dateOneFormat - dateTwoFormat );

 

Please let me know if this is helpful.

 

Thanks

 

I guess format is not working in agent workspace