[AccessD] Stupid DateTime/Calendar Picker Question

That worked.  Thank you very much for your assistance
to my dumb question.

--- Gustav Brock <gustav at cactus.dk> wrote:
> Hi Frank
> 
> Try wrapping these in CDate():
> 
>   datDateTimeStart = CDate([start_date] & " " &
> [start_time])
>   datDateTimeStop = CDate([end_date] & " " &
> [end_time])
> 
> Then, use Format to display your date-time values.
> 
> /gustav
> 
> 
> > Ok....Here's the scenario.  I have a report that I
> > need to run.  It has a start date and time and a
> stop
> > date and time, obviously.  The back-end database
> has
> > the start and end times in DateTime format, I
> cannot
> > deviate from this format in the backend.
> 
> > I have a calendar picker to select start date and
> one
> > to select stop date.  I have a time picker to
> select
> > the start time and stop time.  I have four text
> boxes
> > that take the resultant dates and times from the
> > ActiveX controls, so I can use them.  From there I
> > have two text boxes that convert them to pseudo
> > DateTime start and stop times thusly
> "=[start_date] &
> > " " & [start_time]" and "=[end_date] & " " &
> > [end_time]".  The resultant formats LOOK correctly
> > formatted for the DateTime field.  I.e. they look
> like
> > 9/19/2003 5:00:00 AM.  HOWEVER they don't seem to
> work
> > properly against the ACTUAL DateTime fields in my
> > back-end database when I use a Between statement.
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com