>Is there a function to get the number of days in a month.
>eg. the number of days in any month of any year.
>
>Thanks
>Andrew
Sometime ago I wrote a 10 line function to simply determine the last day of the current month. I kept adding days until the date function determined the data was invalid. Something like this:
...
For I = 1 to 31
lcChkDate=Month...+"/"+STR(I,2)+"/"+Year...
...
IF DATE(lcChkDate)=" / / "
* Invalid Date take Previous I (Day) (I-1)
* as last Day of Current Month
* Define variable here ldDate=DATE(lcChkDate)
EXIT
ENDIF
Endfor
Steve Medvid
Systems Analyst
Environmental Resource Management