Date/Time Variable Type - No Time Zone Adjustments
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 06:30 AM
Hello,
I am looking to make a Copy of the Date/Time Variable type in ServiceNow to use on our Service Portal that does not adjust the Time entered based on timezone.
We are running into issues with the current date/time variables changing the time entered by a submitter whos in PST time zone to the time zone of our Fulfillment team EST. The data being populated needs to be exact and not time zone adjusted. Im not sure how to accomplish this.
An example is, one of our Restaurants we own on the West Coast will submit a ticket to our team to adjust an employees clock in/clock out times. They select 8AM. Our Support teams are located on the East coast and the time adjustments comes through as 11AM and they are entering that into our system, however that is incorrect and 8AM should have been entered by our support team rather than 11AM. Just trying to eliminate this as we have locations in many different time zones and clock in/ clock out hours need to be recorded exactly.
Any help would be appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 06:37 AM
Hmm, maybe you can create a single line text variable and create a client script to copy the value from the date/time variable to the single line text variable.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 08:00 AM
I have this in a Variable set and often times there can be quite a few line items added. Not sure if this would work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-24-2024 04:44 PM
Hi,
Did you ever get a resolution to this?
We are experiencing the same issue. We need the fulfillers to see the actual local time and date entered into a field by the requestor but it is converting it to the fulfiller's local time.
Thanks,
Mandy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2024 05:20 AM
Hi @MandyHill!
No, I ended up just using a single line text and added some validation regex to it to enforce users to input a time, but I am still looking for a actual time field to solve this.
Here is what I did for that!
I created a validation regex named "Time" and entered the information below!
([0][0-9]|(0-9)|([0-9]|1[0-2])):([0-5][0-9])((a|p)m|(A|P)M|(A|P)m|( a| p)m|( A| P)M|( A| P)m)
Its not a prefect solution but it has got us 90% of the way there.
Thanks,
Dillin