Get the difference in seconds between Current Date time and a Date Time Field
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-04-2018 06:16 AM
I am writing a business rule that will check a box if a Due Date Time is more then 5 days from the current date. What is the best way to calculate that?
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-04-2018 06:19 AM
You can use the gs.dateDiff(startDate, endDate, true) function:
The true at the end will make it return the value in seconds. Then you can convert seconds into days.