Re: Date format

Rishabh_N · ‎03-05-2025

in the preferences i can only see dd-mm-yyyy format

Ankur Bawiskar · ‎03-05-2025

it depends on logged in user's date format.

what validation are you planning to run? you can tweak it to ensure it works in all formats.

share the business requirement and what's currently configured

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Rishabh_N · ‎03-05-2025

The scenario is that the selected date should be at least 7 days from the current date. I have written a Script Include and a Client Script for this. However, even when I select a date within the allowed range, it still throws an error when the date format is dd/mm/yyyy. But when I impersonate another user, it works fine when the format is yyyy/mm/dd. this might be because dateDiff is only working correctly with the yyyy/mm/dd format.

var dateValidation = Class.create();

dateValidation.prototype = Object.extendsObject(AbstractAjaxProcessor, {

isDateInRange: function() {

var selDate = new GlideDateTime(this.getParameter('sysparm_deldate'));

var today = new GlideDateTime();

var diff = gs.dateDiff(today, selDate, true);

var isInRange = false;

if (diff >= 0 && diff <= 604800) {

isInRange = true;

}

return isInRange;

},

type: 'dateValidation'

});

Ankur Bawiskar · ‎03-05-2025

@Rishabh_N

no scripting required. you can simply use UI policy and you need not worry about the date format

No Code date validations through (Catalog) UI Policies

use this in UI policy condition

Your Date relative before 7 days from now

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

surajnikam111 · ‎03-05-2025

Hi @Rishabh_N ,

You can use below script to format date field:

var date = new GlideDate();// replace new GlideDate() with the incoming date
var dateNew = date.getByFormat('yyyy/MM/dd'); // now use the dateNew to set the field value

Regards,

Suraj

View solution in original post