Compare Date

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi all,

I have two unbound textbox , begin date and end date. I
created a button to check that the begin date can not be
greateer than the end date and if the begin date is
greater than the end date, a message box pops up. But my
problem is that I'm gettingthe message pop up regardless
of any date. So how do I compare the dates in the two
textboxes.

Here is the line that does the checking:

Dim begindate as date
Dim enddate as date

begindate=Me.textbox1
enddate=Me.textbox2

If begindate > enddate then

do something here...

Thanks for the help.

mike
 
Dim begindate as date
Dim enddate as date

begindate=Me.textbox1
enddate=Me.textbox2

If begindate > enddate then
Click to expand...

try the following

begindate = datevalue(me.textbox1)
begindate = datevalue(me.textbox2)

Joe.
 
Back
Top