Re: IsDate
We do a similar thing to this. It's worth just pointing out 2 quick things though.
If we pass a date of '29/02/2017' the function will see this as a valid date, when of course, it isn't really. Moving the string to a Date variable doesn't raise an error but the date variable will now show 01/03/2017. So it's worth an additional check just to make sure that the resulting date variable, when moved back to a string, still shows the same value as was passed in.
Also, we get users who sometimes hurriedly enter a date such as '10/07/201' instead of 2001 or 2010. DataFlex sees this as being a valid year, but you just know that it wasn't what was intended. So we also just added a check to make sure that the function rejected any dates with a year value that is less than 1753.
Last edited by Peter Bragg; 11-Feb-2019 at 08:43 AM.
"My wife thinks I over-analyse our marriage, which, to be frank completely contradicts the findings of my report." - @MooseAllain