Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-10-17 05:52 PM
I want to use the "DateDiff" functionality under a Decision stage, and want this to give the number of days between 'today' and a dynamic date from my process. "DateDiff" require a Interval input, which is a number. But what the number represent isn't clear.
The description says:
"DateDiff(Interval, Start Date, End Date)
Gets the number of intervals (e.g. days, months etc) between two dates. See the Help documentation for examples and full interval list."
But I don't know what documentation they refer to. And I've tried different number input for Interval, which seems to give output as weeks, months, years, quarters and minutes. But I couldn't find the input for days, which I need.
Do someone know how to use "DateDiff" to give a days interval output?
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-10-17 06:10 PM
In Blue Prism, press F1.
Search for ""Datediff"" and you will get everything you need.
Interval DateAdd DateDiff
0 Year Year
1 Week Week of year (Calendar week)
2 (n/a) Weekday (Full 7 day week)
3 (n/a) Second
4 Quarter Quarter
5 Month Month
6 (n/a) Minute
7 (n/a) Hour
8 (n/a) Day of year
9 (n/a) Day
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-10-17 06:10 PM
In Blue Prism, press F1.
Search for ""Datediff"" and you will get everything you need.
Interval DateAdd DateDiff
0 Year Year
1 Week Week of year (Calendar week)
2 (n/a) Weekday (Full 7 day week)
3 (n/a) Second
4 Quarter Quarter
5 Month Month
6 (n/a) Minute
7 (n/a) Hour
8 (n/a) Day of year
9 (n/a) Day
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-10-17 12:47 PM
Thanks for the help Christer. I had totally forgotten the F1 button 🙂
