Webi LastDayOfMonth issue for March

[former_member544121]

Hello everyone,

i am facing an issue to calculate the last day of current month (this is happening only for MARCH)

Formula used:

=LastDayOfMonth(CurrentDate())

for March should be 3/31/2019?

Is someone experiencing this?

[amitrathi239]

I am also getting the 30/03/2019 which is wrong.My version is BI 4.1 SP08.

It seems it's a bug.

[ayman_salem]

I got the same with version BI 4.2 SP6 patch 300.

it is definitely a bug

[former_member544121 · Accepted solution]

Here some other formula investigation.

Point 3 and 4 could be possible temporary solution

[ayman_salem]

there is now a KBA 2773552 - Formula LastDayOfMonth(CurrentDate()) displays incorrect last date for March month in Web Intelligence report.

with status: The cause is currently under investigation by Development

[ayman_salem]

I got the same with version BI 4.2 SP6 patch 300, 400.

it is definitely a bug (it is only for year 2019)