Solved How can I get the number of days in the month using Calculated field.

[Khurramshaikh47]

Hi, I want to get the number of days in the month using calculated field.
I have some fields:
1) PRDate (Type Date/Time)
2) SalaryMonth (Type Calculated) - Expression used: MonthName(Month([PRDate]))
3) SalaryYear (Type Calculated) - Expression used: Year([PRDate])

Now I want to make new field "NumberOfDays" in this field I want to get total number of days in the month used in PRDate
Some Examples:
If PRDate = 01-Feb-21 then NumberOfDays = 28
If PRDate = 01-Feb-24 then NumberOfDays = 29
If PRDate = 01-Aug-21 then NumberOfDays = 31
If PRDate = 01-Sep-21 then NumberOfDays = 30

Thank you very much,

 

[arnelgp]

NumofDays: Day(DateSerial(Year(PRDate), Month(PRDate) + 1, 0))

 

[Khurramshaikh47]

NumofDays: Day(DateSerial(Year(PRDate), Month(PRDate) + 1, 0))

Thank you so much dear! Solved