need client script to subtract two different date/Time fields and result would be stored in another field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2016 02:21 AM
Hi Guys,
Here i will explain my scenario,
We have two date fields. Those two dates need to be subtracted and the result should be stored in another field.
I need a client script for this.
Could anyone please help me on this.
Thanks in Advance,
Thanks,
Malaisamy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2016 02:47 AM
Hi Balaji,
This i have tried but i am unable to achieve this. I will share my dev instance credentials..could you please help me on this
my Instance: ServiceNow
user: admin
pwd: Riyamalai*1
Table : Test Table(just type in navigation menu);
Calculation fields: Opened date/time, Investigation completed date
Result Field: SI Actual
Please use this and help me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2016 02:48 AM
Check this link ,it may help you:Client Script Date/Time Functions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-27-2016 02:52 AM
Thanks for the reply. But i am very new to the Service now. So some can help me by writing from your side for my Dev instance