>The only "thing" with this solution is that you are depending on the DATE function to work properly...I am not saying that is doesn't work with every date, but I am not sure. With the other solutions, I am more sure that the necessary VFP functions work properly.
>
Hi Joe,

In VFP 6.0 the DATE() function was modified to return compliant dates for this situation. For example, ? DATE(3000, 2, 29) is emtpy because 3000 isn't a leap year. However, ? DATE(4000, 2, 29) does return a date. I've tested this on a number of different dates where it could go wrong and it hasn't yet.

I don't know if this applies here or not, but there's a well known formula known as "Zoeller's Congruence" (geez I hope I spelled that right both words< g >). I'm sure that this function is incorporated into VFP. I'm not sure whether that should be "Zoeller" or "Zeller", but a search on the web will turn up more information.