Days Of A Month

I don't think there is built-in function in Crystal to do that. You can probably write a formula that uses the DatePart() function and the 'y' argument (days in year) and 'd' argument (day part of the date).

Try the "mod" operator in Crystal. For example...

if year(CurrentDate) mod 4 =0 then 29 else 28

This should work if you are trying to calc the # of days in Feb. I'm not actually testing this in Crystal so apologies for any syntax errors

what is the desired result? What are you using the result for?

I actually was able to calculate the days. The only issue was to calculate the days in Feb and this is how I was able to calculate it :

If (Remainder(Year(CurrentDate), 4) = 0 and
        Remainder(Year(CurrentDate), 100) <> 0) or

             (Remainder(Year(CurrentDate), 400) = 0)

                   then 29

                            else 28

 

Thanks for all help.

thought Id share this as I recently resolved this with a custom formula, exactly what you did but maybe a bit more reusable:

function (numbervar argYear)
if argYear mod 400 = 0 then true
else if argYear mod 100 = 0 then false
else if argYear mod 4 = 0 then true
else false

Day(dateadd('d',-1, date(yyyy,mm,dd))) So basically you subtract one day from the first day of the month following the month you want to know how many days there are. The day() function willl return 29 where the date you entered was 2008,03,01. The reason I put in the date() function is to show you how you would programatically create it