I have the following code to add one year to a Date element:

MembershipEnd = MembershipStart + 365.25 

But if the Start date is blank the End date calculates to 12/31/2001.  Is there some type of default date for a blank?

I have already modified the code to only execute if Start date is not blank, but I am curious about why 12/31/2001 comes up if Start is blank.

Will 12/31/2000 always be a basis if a blank Date element is referenced in formula?  So, if we see 12/31/2000, where we ecpect to see something else, can we use that as an indication that the referenced date element must be blank?

It is not always easy to use a Date conditionally.  Suppose we are builiding strings or formulas calling multiple dates, must we write conditional traps for each Date called? 

I think that some type of null value would be better than a predefined date.  At least a null might provide an ERROR in a calculation, whereas a date will provide a valid calculation process, but an invalid result, with no indication of the problem.

Just trying for a better understanding of what is under the covers to have a better idea of what to expect with certain conditions.

No access right now, but you may be right....too many hours in front of the screen.....

But even if that is correct, default = 0, I would still prefer to have a NULL that could bring back some type of error notification vs. allowing calculations and strings to be processed.

Thanks for listening.