End of Month function returns an error

jb_bryant (23 posts)
January 17, 2019 09:31 AM
Accepted Answer

I've been using this function for a date for a long time:

@EndOfMonth(@now("d",-1,month))

This month, the function is returning this error:

Invalid Pattern: Evaluation of function "@EndOfMonth(@now("d",-1,month))" failed: Year, Month, and Day parameters describe an un-representable DateTime. (Text, position 0)

@now("d",-1,month) still returns 12/17/2018 so it's definitely an issue with the end of month function.

I tried @EndOfMonth(12/17/2018,ddMMyyyy) as well as @EndOfMonth(12/17/2018). Both say "Invalid Pattern: Evaluation of function "@EndOfMonth(12/17/2018)" failed: Year, Month, and Day parameters describe an un-representable DateTime. (Text, position 0)"

This topic has an accepted answer. Jump to it.
Bill Staff (599 posts)
January 17, 2019 11:14 AM
Accepted Answer
We're looking into this.
Bill Staff (599 posts)
January 17, 2019 12:44 PM
Accepted Answer
This problem has been fixed. You can download the update here. Be sure you have updated to Report Commander 2.6 before you apply the hotfix.
jb_bryant (23 posts)
January 18, 2019 08:11 AM
Accepted Answer
That worked. Thanks!

Replies are disabled for this topic.