After checking my daily wtf i started debugging some code because someone had reported a, surprise, bug.
anyway, context is not really important but ill give it anyway:
MSaccess form, with 2 date fields. Meta-information suggests that date 2 is always after date 1, though not both information shoudl even exist (is about certain irl events, but IF they both took place, date 2 is always after date1)
so there is a check if date2<now() (date shouldn't be in the future) and... date1<date2
-> am i correct in thinking that if date1 doens't exist, it should always be smaller than any date? explicitly smaller than any valid date?
my quick sollution was to just check if date1 was null (vb: IsNull(date1)) before checking for just Now() or before checking for Now() and the other date...
still made me go WTF. is it my weird head, or should the original code have worked?
EnnaN
@EnnaN
0
Reputation
1
Posts
44
Profile views
0
Followers
0
Following
Best posts made by EnnaN
This user hasn't posted anything yet.
Latest posts made by EnnaN
-
Null > something.. is this a wtf or am i missing something