Is there support for negative field duration

Troya1
Mega Guru

Note:  We are moving to Orlando in a couple of weeks!

We want to calculate Days until Go-Live.  If the current date is > than the Go-Live, the field should display minus the number of days pasted (as seen below). 

Previous documentation has stated the ServiceNow does not support negative numbers in these fields. 

Will that change in Orlando?

find_real_file.png

1 ACCEPTED SOLUTION

sachin_namjoshi
Kilo Patron
Kilo Patron

duration fields can not store negative values.

FX Currency field type in orlando supports negative field values.

 

https://docs.servicenow.com/bundle/orlando-release-notes/page/release-notes/now-platform-user-interf...

 

Regards,

Sachin

View solution in original post

3 REPLIES 3

sachin_namjoshi
Kilo Patron
Kilo Patron

duration fields can not store negative values.

FX Currency field type in orlando supports negative field values.

 

https://docs.servicenow.com/bundle/orlando-release-notes/page/release-notes/now-platform-user-interf...

 

Regards,

Sachin

Namita Mishra
ServiceNow Employee
ServiceNow Employee

Hi @Troya ,

If the current date is > than the Go-Live: you may want to display value in red which would be an indication that it is overdue...

Thanks,

Namita Mihsra

Thank you for you reply.

 

We did add an indicator for the negative calcualtion but the issue is we need to know how many days the project is behind.  The indicated does not show an actual number in the field if it is negative.  We are using the background-color field style. 

Do you have any other suggestions?

 

find_real_file.png