Question:
I’m using Web Datablade and IIF to develop Web pages. I need validation (other than JavaScript) on date inputs. How can I validate dates on IIF, using SPL or Web Datablade?
Answer:
I’m not a user of Web Datablade, so I don’t know if the validation is built into the product, but what I’d do is take a suspected date and try to insert it into a dummy table with a date field. Then check the error code to see whether the insert was successful. If it was, then you have a good date.