>>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.
I hope it works for you (if you actually do use the fuction). I am sure VFP will do things right...so this will work.
I was just making a useless observation :)
Take care,
Joe
Joseph C. Kempel
Systems Analyst/Programmer
JNC