How to change date variable on catalog item to accept date in mm-dd-yyyy format

[BijoyDeb]

Hello everyone,

I have one record producer on which I have create variable of Date type.

By default, its showing format as YYYY-MM-DD

I have mapped this variable to a date type of field in target table.

Is it possible to change this format into MM-DD-YYYY? Both in catalog item and target table as well?

If yes, how can we do that?

Please help me on this.

Thanks

[Najmuddin Mohd]

Hello @BijoyDeb 

Navigate to sys_properties.LIST and filter with Name = glide.sys.date_format

It defines the global date format to be shown in ServiceNow.

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

[Ankur Bawiskar]

@BijoyDeb 

the format is shown based on date format of the logged in user.

Don't worry and map it using script

how are you doing it currently?

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

[Ankur Bawiskar]

@BijoyDeb 

Hope you are doing good.

Did my reply answer your question?

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

[Babu Govind]

Hello @BijoyDeb,

Please make sure the below steps are checked before updating the format.
1. Check whether the format is same for all users or only for the logged in user?
2. If only for logged in user, then please check the preferences of the user under the My profile.

3. If the format needs to be changed to all users then please use the below property to update the format. But, please be informed that updating the property will impact the format across instance.

Hope this information is helpful, If this resolves your issue please mark this case as solution accepted or helpful which will benefit everyone in future.
Best Regards,
Babu