FoxPro2.5/2.6 billing cycle includes 2/29/2004 1

[LMLaird]

Need help in resolving a problem that does a date calculation for the month of February 2004 which is a leap-year. I know this was pointed out during Y2K as a potential problem date. Don't know if there is a resolution. Anyone else having this issue?
When the application has to perform a calcuation for billing that includes Feb 2004 It returns a "Data type Mismatch" error.
However, both members of the equation have been defined as numeric data types.

 

[JRB-Bldr]

You might want to provide us with the portion of your code which generates the error so that we can better understand what you mean by -- "both members[??] of the equation have been defined as numeric data types"

As a reference point, in FPW 2.6...
{03/01/03} - {02/01/03} = 28
{03/01/04} - {02/01/04} = 29
{03/01/05} - {02/01/05} = 28
so things appear to be calculating correctly, leap year or not.

Therfore an example of what you are doing for your "date calculation" might be helpful.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[rgbean]

Do you mean for 2000? It even seems to give right!

? {03/01/2000} - {02/01/2000} && 29
And 
?{02/29/1996}
?{02/29/2000}
?{02/29/2004}

All return non-empty values.

Rick

 

[LMLaird]

Thanks for responding, found a problem earlier in the code.