Summing filtered records

[Darren_Murphy]

@Robert_Petitto

Has an official bug report been filed?

I don’t think I ever submitted a bug report, but I did create a GitHub issue the first time I noticed it, almost 2 years ago.

The worst thing about this is that it can be very difficult to reproduce, and even more difficult to debug when it breaks. I had a fairly lengthy rant about it below:

Time Format

The other thing you need to do is test it at different times of the year. Early on, when I was trying to use it, I found that it would sometimes get the day and month mixed up, but only under certain circumstances, and only if the date was ambiguous. For example, today is September 25th. In the US, they write that as 9/25/2022. In the real world, we write it as 25/9/2022. But either way, it’s obvious that it’s September 25. It can’t be anything else, because there is no 25th month. But, le…

It’s quite possible that it’s been fixed and now works perfectly in all cases (although my Github issue was never closed or commented on), but quite honestly I’m just not willing to take the chance when I know there are other methods to get what I need that I can be confident will work in all cases