Results 1 to 10 of 18

Thread: IsDate

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #16
    Join Date
    Feb 2009
    Location
    Birmingham, UK
    Posts
    1,232

    Default 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •