Date Error

[chidi]

To all you great coders, please help!!

I am having a date problem.
I have three fields:
Lov_date, deadline_date, and comleted.
completed is boolean = Yes/No.
What I am trying to accomplish here is that if lov_date is less than deadline_date then
completed should be yes
else
completed is No.
The problem is deadline_date contains some empty values.
As a result, I am trying to capture that by saying
if deadline_date is null, then completed should be No as well. That is the spec.
This is my code but it is not working.
Any help would be GREATLY appreciated:

if deadline_date = &quot;&quot; or date1 <= deadline_date then
completed = 0
else
completed = -1
end if
This is not working. Please help!!!
Thanks in advance
completed = NO

 

[segmentationfault]

&quot;&quot; is not null, it is simply a string of length 0. That's not important at the moment though, as it doesn't apply to your problem.

Dates are stored numerically, but represented in human readable format. Thus, a blank date should evaluate to 0. Try replacing

deadline_date = ""

with

deadline_date = 0

and I think it will work.