Field Type "Schedule Date/Time"

[Vinayak Belgaon]

I found a field type on the fiscal_period table with the type "Schedule Date/Time" 

Is this field type deprecated, i am not able  to find any documentation on this field type?

[Chuck Tomasi]

I found an example of them on the OOB table cmn_schedule_span. They appear to work like standard date/time fields, but may have other behavioral attributes behind the scenes.

The start date time and end date time do not appear on the form. Instead a UI macro populates them from a "cleaner/smarter" interface.

Do you have a need for such a field type or just curious?

[Vinayak Belgaon]

I am working on ITBM, and the table i am referring is fiscal_period. There are two fields one is the Fiscal Start Time(Date/Time field type) and the other one is the Start Date Time(Schedule Date/Time field type). So i need to compare if the cost_plan record is in the respective fiscal and for that i am comparing the date time fields. The display Value is similar to that of the Date time field type, but on the server side i get the value something like this"20240630T000000" 

So my query is what is this value type, should i use this while comparing with other date time values? and i tried to convert it using the GlideDateTime but was not able to. One good thing is that if i try to get the display value of this field i get the date time in system timezone and not user based TZ.

[Chuck Tomasi · Accepted solution]

Thanks for the info on the values stored in that field type. That format is in YYYYMMDDTHHmmSS.

The "T" is a separator between the date and time. it's a pretty standard format on the internet. Some ANSI, or IEEE standard number that I don't recall at the moment.

If the display value comes back with a standard ServiceNow format, then you can input it in to a GlideDateTime and use it as a comparison that way.

Why we have this difference, I don't know. I've added it to my list of questions to ask a platform developer/product manager next time I get the chance.

[User339333]

Hi Chuck,

Ran into this article trying to find some answers to my recent community question regarding this Schedule Date/Time field. There seems to be a translation issue while trying to populate another field with the contents of this one using a client script......

Need Help with Passing Date/Time in a "Schedule Date/Time" formatted field to a "Date/Time" field - ...

Is this something that you can help me with? I'll await a reply on my question article.