Can't get _DateIsValid to work in my loop

[dar100111]

First off,  I didn't have <Date.au3> included at first and now I do.  I thought it would have received an error but maybe not.

Is there a reason why my If Statement wouldn't work for _DateIsValid in my loop with array that I have?

#include <String.au3>
#include <ButtonConstants.au3>
#include <EditConstants.au3>
#include <GUIConstantsEx.au3>
#include <StaticConstants.au3>
#include <WindowsConstants.au3>
#include <INet.au3>
#include <excel.au3>
#include <array.au3>
#include <Date.au3>
#include <OutlookEX.au3>

$oExcel = _ExcelBookOpen( @ScriptDir & "\Bulk Email Tool.xlsm")
_ExcelSheetActivate($oExcel, "Contacts")
Global $contactarray = _ExcelReadSheetToArray($oExcel, 2, 1, 0, 2)
_ExcelSheetActivate($oExcel,"Info")
Global $aArray = _ExcelReadSheetToArray($oExcel);This will contail all the info to send to the branches
$rows = $aArray[0][0]
$cols = $aArray[0][1]
;Checking if dates need to be formatted through the whole array
For $i = 1 To $rows Step 1
    For $c = 0 to $cols Step 1
        $check = $aArray[$i][$c]
        MsgBox("", "", $check)
        If _DateIsValid($check) Then
            $date_converted = StringRegExpReplace($check, '(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)', '$1/$2/$3 $4:$5:$6')
            $aArray[$i][$c] = $date_converted
        EndIf
    Next
Next

_ArrayDisplay($aArray)

The array can contain date values of Excel that get converted to "20140417000000" format.

The code below works as follows individually.  Just not in my loop.  I'm probably doing something incorrect but can't seem to figure it out.

Can anyone see the error?

$string = "20140417000000"
Local $sDate = StringRegExpReplace($string, '(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)', '$1/$2/$3 $4:$5:$6')
; msgbox(0,"", $sDate)

If _DateIsValid($sDate) Then
    MsgBox($MB_SYSTEMMODAL, "Valid Date", "The specified date is valid. "&$sDate)
Else
    MsgBox($MB_SYSTEMMODAL, "Invalid Date", "The specified date is invalid.")
EndIf

My array contains examples below.  (just copied these from the array display function.

MIA|231817893|230244171|20140416000000|65.2|16

SFO|231818809|230148118|20140417000000|197.88|15

ORD|231819883|230025639|20140418000000|560|14

 

Edited May 5, 2014 by dar100111

[BrewManNH]

You're not converting the date before you check it, you're trying to do that afterwards.

[dar100111]

It seems to be looping through everything like I want.

 

I have also just tried the below and it doesn't catch it either.

For $i = 1 To $rows Step 1
    For $c = 0 to $cols Step 1
        MsgBox("", "", $aArray[$i][$c])
        If _DateIsValid($aArray[$i][$c]) Then
            $aArray[$i][$c] = StringRegExpReplace($aArray[$i][$c], '(\d{4})(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)', '$1/$2/$3 $4:$5:$6')
        EndIf
    Next
Next

[BrewManNH]

Was I unclear?

In your second example you convert the raw date string into a format that _DateIsValid can recognize. So it passes validation.

In your loop code, you're grabbing the data from excel into an array, and then trying to compare the raw data, with the function _DateIsValid, which of course is going to fail because instead of being formatted text, you're trying to validate "MIA|231817893|230244171|20140416000000|65.2|16" as a date, and it clearly isn't.

[dar100111]

Gotcha Brew Thanks.  I was thinking that conversion would cause an error. Thank you sir.  Just needed a good eye.