Calculate the no of days in the Present Month

[Former Member]

Hi All,

I am working on a report and I need to find the no of days in the month according to the date entered by the user.

I am using User Response function to get the date.

Eg:

  if user has entered the date as 4th March 2016 then it means that month is march ,so I want no of days in month as 31(March has 31 days ).  Similarly, for April it should come as 30 days.

Please help.I need this formula.

[amitrathi239]

use this.

=DayNumberOfMonth(LastDayOfMonth(ToDate(userresponse("Enter date");"dd/MM/yyyy")))

According to prompt date format change the date format in the formula.

[Former Member]

Hello,

Try this link i hope it work

SAML Response from SAP Cloud Identity

Calculating Work Days Between Two Dates in Crystal Reports

-Bhavesh Samant

[Former Member]

Hi,

I want this formula in webi rich client.