topic RE: #BPTechTips - Date Intervals in Product Forum

#BPTechTips - Date Intervals

AndrewPascal — Tue, 27 Sep 2022 15:44:00 GMT

If - like me - you're a human, you probably have trouble dealing with those "magic numbers" in the DateDiff() and DateAdd() functions. You know - DateDiff(6, [Start Date Time], Now()) counts the number of elapsed... somethings. But what? Does 6 mean we're counting hours? Or minutes? Or even months?

To make this stuff easier to read - and easier to write as well - I create a one-row collection called Date Intervals, and make it globally visible

Initialise all the fields to the secret magic numbers from the Blue Prism help file:

Now I can refer to [Date Intervals.Minute] instead of "6", and it's easy to understand what the calculation's doing:

Just copy the one-row collection to any object or process to enjoy never having to work out those pesky Date Intervals again 🙂

Hope you find this helpful.

------------------------------
Andrew Pascal
------------------------------

RE: #BPTechTips - Date Intervals

ManpreetKaur1 — Tue, 27 Sep 2022 19:49:00 GMT

Thanks for sharing @AndrewPascal

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

RE: #BPTechTips - Date Intervals

JeremyRTDean — Tue, 27 Feb 2024 03:16:00 GMT

Love this, great suggestion and well illustrated!

------------------------------
Jeremy Dean
------------------------------

RE: #BPTechTips - Date Intervals

johan.m — Tue, 27 Feb 2024 13:58:00 GMT

Why don't you use simply :

ToMinutes([DateTime 2] - [DateTime 1])

------------------------------
Johan Michiels
------------------------------

RE: #BPTechTips - Date Intervals

JeremyRTDean — Tue, 27 Feb 2024 19:34:00 GMT

I think the point was that many people don't remember the numeric representatives of the time periods (Day is 9, Month is 5 etc.) and they're not very easy to find, especially when you're trying to work out something quickly. The numbers are also an easy way to hide bugs in your code, as I found yesterday when I realised I'd used a 4 rather than a 5 in a DateDiff calculation...

------------------------------
Jeremy Dean
------------------------------

RE: #BPTechTips - Date Intervals

johan.m — Wed, 28 Feb 2024 13:40:00 GMT

I agree Jeremy I just wanted to offer an easier way to do it knowing that Bleuprism warns that DateDiff is deprecated !

Time to get rid of it 😉

------------------------------
Johan Michiels
------------------------------

RE: #BPTechTips - Date Intervals

JeremyRTDean — Wed, 28 Feb 2024 18:38:00 GMT

Interesting! I needed to identify transactions where the different between start and end dates was no more than 3 months so I did this:

(DateDiff([Date Intervals.Month], [RFC Start Date], [RFC End Date]))<=3

I could have used ToDays and 90 as you suggest.

------------------------------
Jeremy Dean
------------------------------