A Bevy of BIFs: Dealing with a Bad Date
April 15, 2009 Susan Gantner
In an earlier tip, I talked about how %Date simplifies our logic by converting our “date” values stored in numeric or character fields into true dates. In that tip, I mentioned that using %Date could potentially result in an error message in the event your “date-like” fields contain an invalid date value, such as zero or blank or a month value of 25. Here I’ll cover how to avoid getting run time errors due to bad date values. Since many of the “date-like” fields we deal with in our applications come from screens, database fields, HTML or XML documents, |