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.