Date problems in Dbase III+

[nicksteel]

I use DB3 to check calculations in software I am developing that uses DBF files. I have it installed on Windows7 Pro 32bit with XP SP2 compatibility. The problem is comparing a date to CTOD(' / / ').

= or <> give the same results.

If I substitute [highlight #FCE94F]> CTOD('01/01/01')[/highlight] for [highlight #FCE94F]> CTOD(' / / '}[/highlight], I get different results. All my dates are empty or during 2013. I have tried SET CENTURY ON.

 

[EzLogic]

can you post your code?



Ali Koumaiha
TeknoSoft Inc.
Michigan

 

[nicksteel]

Count for af = CTOD(' / / ')
Count for af <> CTOD(' / / ')

in DbaseIII+

 

[EzLogic]

What your wrote should give you the desired results. you are counting for the field "af" to be either blank or not blank.
try this:
count for empty(af)
count for .not. empty(af)


are you not getting the desired counts?

Ali Koumaiha
TeknoSoft Inc.
Michigan

 

[nicksteel]

count for empty(af)
count for .not. empty(af)
work in my minigui code, but are invalid function in DbaseIII+

Thanks.

 

[dbMark]

This was an issue with dBase date comparisons at least up through version 5, the last one I'm familiar with. Comparing to an empty date always returned .F. (false). Why don't you use DTOS() function which typically returns a string in the format "CCYYMMDD"? An empty date yields an empty string and hence can be accurately compared.

? CTOD(DATE()) = CTOD("  /  /  ")
.F.
? CTOD(DATE()) <> CTOD("  /  /  ")
[COLOR=red][b].F.  && wrong[/b][/color]

? DTOS(DATE()) = DTOS("  /  /  ")
.F.
? DTOS(DATE()) <> DTOS("  /  /  ")
[COLOR=green][b].T.  && correct[/b][/color]

 

[JCreamerII]

I have used an actual date. I use one earlier than possible within the data set. Also, test the month "IF MONTH(DATE()) = 0" should work for you.

Jim C.