- David Merinos
- PowerBuilder
- Wednesday, 15 March 2017 05:32 PM UTC
Our program has DataWindows with DateTime fields and we allow the user to Query for information with QueryMode; one button turns QM on and another button causes it to Retrieve with the information the user put in.
Our datetime fields have the following mask: "dd/mm/yyyy" because of our locale (Mexico).
However, when the user puts in something like "01/01/0001" the following error displays:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Which is an SQL error, I've been digging around but haven't found anything related to PB and how to fix this isssue, I was wondering perhaps there's a way to tell the object to fix the date format before making the retrieve.
¡Thanks!
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.