Duration Variable Catalog

Kalaiarasan Pus
Giga Sage

Is there any alternative for using the duration field on catalog as it is not available out of the box? Anything that is already created by someone?

4 REPLIES 4

khabibulan72
Kilo Expert

Hi Kalai - can you please give more details? It would be helpful to know what you're trying to do and how it is that you require and out-of-the-box solution.


Duration type field is present at the table level but there is no equivalent type of variable that can be used on the record producer/catalog. So was thinking if somebody had the same requirement and what approach they adopted to overcome this.


OK that helps to better understand what you're looking for. I'm wondering if the duration is something you are even able to capture at the variable state. What I mean is that if you're collecting information in a record producer you're not really yet dealing with a meaurement of time that can be represented as a duration. Sounds like you're trying to estimate rather than evaluate. Maybe if you use a start time variable and an estimated end time variable you can then push those out to fields in your target table. There's a wiki article about how a date time field on a table can be modified to display as a duration. I don't want to give you bad advice but it seems to me like it's not a duration until some work has been done on it at the table level.



http://wiki.servicenow.com/index.php?title=Using_Date_and_Time_Fields#Displaying_Resolve_Time_as_a_D...


Preciously what I told the customer before posting this. But they have a field on the change table which needs to be entered at the record producer rather than calculating using GlideDateTime method .. It is used to specify the fallback time of a change request..