Hi Jim,
The documentation is not 100% complete (it's a beta, after all), but you're right - QUARTER() has been changed so that a blank date returns a zero instead of an error.
>There was a wish that the QUARTER() function return a zero if the date supplied was 'blank'.
>
>I tested this in VFP8 and got a ZERO returned, which is GOODNESS (it errors in VFP7SP1).
>
>However, neither the Reference documentation for the QUARTER() function, nor the "What's New" stuff, mentiones this (that I can find) and the Reference doc says only 1, 2, 3 or 4 can be returned.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
