By combining DROPLEVEL(EXPAND()), you can easily get the days in a month

By using

DROPLEVEL(EXPAND(1,“Day”),”Day”)

you get the days in a month. This holds true even for leap years and other irregularities.

Similarly, by using

DROPLEVEL(EXPAND(1,“Day”),“Month”)

you get the number of days in each quarter.

Finally, by using

DROPLEVEL(EXPAND(1,”Day”),”Quarter”)

You can get the number of days in each year.


Contact

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.