Comparing dates

[savok]

How can I compare 2 date fields, one coming from an oracle table another from VB text box. I need to format them somehow so I can compare them but have no clue how.

txtDate = Format(txtDate.Text, "mm/dd/yyyy&quot

Select * from table where date_field > '" & txtDate & "'

I need to format date_field to the same format as txtDate. Anyone know how I can do this?

Something like
Select * from table where (date_field, 'mm/dd/yyyy') > '" & txtDate & "';

Anyone know the correct syntax?

 

[savok]

ahhh found it in case anyone interested


Select * from table where date_start > to_date('" & txtDate & "', 'MM/DD/YYYY')"

 

[edderic]

Select * from table where date_field > #" & txtDate & "#"

Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com