Number of days in Feb 1

[alvintse]

Does anyone know any function in Crystal Reports 9 that can tell how many days on Feb for any year?

Thanks.

 

[lbass]

The following will return the correct number of days for February, where {?year} is a discrete number parameter:

datediff("d",Date({?year}, 02, 01), Date({?year}, 03, 01))

-LB

 

[alvintse]

Thanks a lot!! That's pretty tricky!

 

[chelseatech]

Or you could try
Day(Date({?year},3,1)-1)

This will work for any version of CR. DateDiff (in the example above) is only available from Cr8.0 onwards.


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm