If with date function not working

[Champak]

Can someone tell me why the following isn't working?

If _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) <= 2 Then 
        $PriceDate = "Price is recent and most likely still in effect."
        GUICtrlSetColor($Label_Date,0x00EC00)
    ElseIf _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) >= 3 And _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) <= 4 Then
        $PriceDate = "Price is 3 to 4 days old."
        GUICtrlSetColor($Label_Date,0xFF860D)
    ElseIf _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) > 5 Then 
        $PriceDate = "Price is older than 5 days."
        GUICtrlSetColor($Label_Date,0xFF0000)
    EndIf

It only seems to see the first "IF" function no matter what the date difference is. The difference is always "0". If I put the consolewrite inside the first "IF", I can see that the date is hitting ranges where they should actually be going into the other "elseif" functions, but the calculations difference always come back as "0".

What am I not seeing?

[spudw2k]

The only thing I can think of is maybe the format of your timestamp is incorrect. What date for example is stored in your array?

msgbox(0,"",$Full_List[$Position][5])

I think it has to look like this. "YYYY/MM/DD hh:mm:ss"

Edited April 10, 2008 by spudw2k

[Monamo]

Can someone tell me why the following isn't working?

If _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) <= 2 Then 
        $PriceDate = "Price is recent and most likely still in effect."
        GUICtrlSetColor($Label_Date,0x00EC00)
    ElseIf _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) >= 3 And _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) <= 4 Then
        $PriceDate = "Price is 3 to 4 days old."
        GUICtrlSetColor($Label_Date,0xFF860D)
    ElseIf _DateDiff( 'd',$Full_List[$Position][5],_NowCalc()) > 5 Then 
        $PriceDate = "Price is older than 5 days."
        GUICtrlSetColor($Label_Date,0xFF0000)
    EndIf

It only seems to see the first "IF" function no matter what the date difference is. The difference is always "0". If I put the consolewrite inside the first "IF", I can see that the date is hitting ranges where they should actually be going into the other "elseif" functions, but the calculations difference always come back as "0".

What am I not seeing?

Have you done a verification of the data being read from the array? If so, can you post a sample of the output to help determine if it's perhaps a data structure validation issue?

Ex:

ConsoleWrite($Full_List[$Position][5])

[Champak]

It was the format, I forgot I changed the original format before I initially put it in the array. Thanks for the heads up.

Edited April 10, 2008 by Champak