Field Type "Schedule Date/Time"

Vinayak Belgaon · ‎10-09-2019

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 · ‎10-10-2019

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.

View solution in original post

Vinayak Belgaon · ‎10-09-2019

Also saw the Live stream where you did a quick research.

Thank You