Date Formate for differ users causing issue while performing Date validations.

[Rajyalakshmi]

1.We need to validate date field value should be in 12 months range from current date.

2.In our ServiceNow instance we have different date formats  for few users.

3.Our date validation script is working fine for the users preference date format is YYYY-MM-DD .for other users who are having different date format for example yyyy/mm/dd or dd-mm-yyyy ,script getting failed.

4.Could you please suggest is there any global functionality is there to set date format in YYYY-MM-DD irrespective of user preference date format .

[Ankur Bawiskar · Accepted solution]

@Rajyalakshmi 

you should use UI policy so that date format is taken care of and you need not worry on it.

No Code date validations through (Catalog) UI Policies 

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

[JackieZhang]

please share your code

[OlaN]

Hi,

It sounds like you are doing the comparison on the client side, with some form of client script ?

Instead, you can use the input from the user, send it into a script include and evaluate if the users selected date is within 12 months or not.

Ask if you would like me to explain in more detail.

[VijayKumarDodde]

Always convert the date to a standard format (e.g., yyyy-MM-dd) in your script, regardless of the user preference.

Try passing date variable to script include and convert to yyyy-MM-dd format and compare.

[Ankur Bawiskar · Accepted solution]

@Rajyalakshmi 

you should use UI policy so that date format is taken care of and you need not worry on it.

No Code date validations through (Catalog) UI Policies 

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