Function - How many days of the month

[McAhren]

Hi,
Does anyone know the function in Crystal to count how many days are in the current month?

Thanks for your help, LM

 

[Naith]

There isn't one.

You can use a formula like:

WhilePrintingRecords;
NumberVar MaxDay;

If Month(Date) in [4,6,9,11]
Then MaxDay = 30
Else
If Month(Date) in [1,3,5,7,8,10,12]
Then MaxDay = 31
Else
If Month(Date) = 2
Then If Year(Date) in [2000,2004,2008,2012]
Then MaxDay = 29
Else MaxDay = 28;

Naith

 

[McAhren]

Thanks for your help!

LM