topic Thanks for the help Christer. in Product Forum

DateDiff

DennisLaursen — Mon, 30 Oct 2017 17:52:00 GMT

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?

In Blue Prism, press F1.

Christer_Tellefsen — Mon, 30 Oct 2017 18:10:00 GMT

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

Thanks for the help Christer.

DennisLaursen — Tue, 31 Oct 2017 12:47:00 GMT

Thanks for the help Christer. I had totally forgotten the F1 button 🙂