Subtract No of Days from Date field to set New Date in a field (Scoped App)

[Rush B]

I need to Subtract No of Days(integer field) from a Date field to set New Date in a field for a Scoped App using BR please help me with the logic for scoped application to get the new Date.

Example

field a -> 2024-02-21 (Type - Date)

field b -> 5 (Type - Integer)

I need to set (a-b) as a date in a field. This has to be done using BR which uses a scoped app table.

[Dr Atul G- LNG]

Hi @Rush B 

What is use case, if you provide more details, that will be good. 

[Rush B]

Sure , Example

field a -> 2024-02-21 (Type - Date)

field b -> 5 (Type - Integer)

I need to set (a-b) as a date in a field. This has to be done using BR which uses a scoped app table. 

[Dr Atul G- LNG]

Hi @Rush B 

https://www.servicenow.com/community/developer-forum/how-do-i-subtract-days-from-a-date-time-field-u...

https://www.servicenow.com/community/developer-forum/subtract-days-from-date-time-field/m-p/1540493

[piyushsain]

Hi @Rush B 

You can use the script

var gdt = new GlideDateTime('fieldA'); //GlideDateTime to be used even if the type of field is date

gdt.addDaysLocalTime(fieldB * -1);

var newDate = gdt.getDate(); // use this newDate to save in the other field