number of days in the month of currentdate-1

[crsdev]

hi friends ,
couldn't find the formula to find out the number of days of a particulate month. Is there a formula for this in crystal reports XI.
I wanted something like nofdays(currentdate-1)
Thanks for your help in advance.

 

[dgillz]

Of a particular month, or this month?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[crsdev]

thanks for the response dgillz,
I am looking for number of days of the month of currentdate-1.
i.e. if currentdate is Sept-1st it would be number of days of aug=31.
if currentdate is setp-2nd it would be number of days of sept= 30

 

[kskid]

Try this

day(dateserial(year(currentdate-1),month(currentdate-1)+1,1-1))

-lw

 

[crsdev]

thanks kskid,
that worked, thought it took me some time to figure out why you did a '+1' after month(currentdate-1).
how did you come up with it. you must be a CR formula guru..

thanks again.

 

[kskid]

You are welcome.

I just became very involved with using dateserial in many of my monthly reports other than lastfullmonth.