How I have compare date?

epatrik · #1 (**permalink**) 09-20-2007, 09:05 AM

If Date(Table2.Cell",1)) >= Date(Calendar4.Value) Then
Code.....
End if

Error description:
Input stringer was music land and correct form.

Erel · #2 (**permalink**) 09-20-2007, 09:09 AM

Just remove the Date keywords:
If Table2.Cell(...) >= Calendar4.Value Then

epatrik · #3 (**permalink**) 09-20-2007, 09:33 AM

Same problem.

Calendar4.Format = "dd-mm-yyyy"
X = "30-09-2007"

If X >= Calendar4.Value Then
MsgBox(X)
End If

Erel · #4 (**permalink**) 09-20-2007, 09:36 AM

You need first to convert the string into a date value using DateParse:
If DateParse(X) >= Calendar4.Value Then...

epatrik · #5 (**permalink**) 09-20-2007, 09:54 AM

Much thanks already it steps.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
working with date	gjoisa	Questions & Help Needed	3	03-29-2008 09:40 AM
How to get the value of date substraction ?	gjoisa	Questions & Help Needed	1	02-11-2008 09:15 AM
Date and Time	Erel	Tutorials	0	09-24-2007 09:05 AM
Can we compare imagelist items?	Cableguy	Questions & Help Needed	1	06-02-2007 05:03 PM
How can i compare 2 Dates	Fontanus	Questions & Help Needed	3	05-04-2007 09:37 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)