Thread: If statement with Date

Hello,

I don't understand how it works, can someone check my syntax. It does not give any error but it won't do what I expect :

data_date/data_time are a Date Type, date_start and time_start too.
When I have checked in the debug mode, the data_date and data_time has the same value and should go inside the if statement.

    
If data_date = date_start And data_time = time_start Then
   index_start = 10
End If

Thank you in advance.

ok...
while in debug mode.. what is the value showing for date_start and time_start...

Condition says... if data_date equals date_start and data_time equals time_start.. then it will go inside the if statement.

Regards,
DILIPandey

<click on below 'star' if this helps>

maybe...

If DateDiff("d", data_date , date_start )<0 and DateDiff("s", data_time , time_start )<0 then
   index_start = 10
End If

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save