Hi all,
I have a couple of fields that are built up from strings. They are both in YYYYMMDD format.
The first one is:
YMDA$, and contains a value of "20020220"
The second is:
YMDB$, and contains a value of "20000315"
When I try to compare the two by saying:
If Val(YMDA$) > Val(YMDB$) Then 'Which it clearly is
Blah, blah......
End If
Nothing happens. The program runs right by the if statement like there was nothing there. The logic is imbedded in a BIG .exe with 7 modules, and I cannot single instruct through it.
I have tried having it print the strings, and the str$ of the Vals, and the print leads me to believe that the fields contain what they are supposed to.
The only conclusion that I can come up with is that QB is not able to compare values that are that large.
ANY help would be appreciated.
Thanks,
Tranman
I have a couple of fields that are built up from strings. They are both in YYYYMMDD format.
The first one is:
YMDA$, and contains a value of "20020220"
The second is:
YMDB$, and contains a value of "20000315"
When I try to compare the two by saying:
If Val(YMDA$) > Val(YMDB$) Then 'Which it clearly is
Blah, blah......
End If
Nothing happens. The program runs right by the if statement like there was nothing there. The logic is imbedded in a BIG .exe with 7 modules, and I cannot single instruct through it.
I have tried having it print the strings, and the str$ of the Vals, and the print leads me to believe that the fields contain what they are supposed to.
The only conclusion that I can come up with is that QB is not able to compare values that are that large.
ANY help would be appreciated.
Thanks,
Tranman