DateValue Help Needed

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

I am trying to run a query with the DateAdd Function
nested inside the DateValue function. The field is a date
and time field within a the primary table
called: "tbl_totProd". The query's expression looks like
this Date1: DateValue(DateAdd("h",-7,[Date])).

If this field is used as a data source for a drop down box
for setting criteria on criteria form for running reports,
simply setting the sort type to:"Ascending"
or "Descending" causes an error: "Data Type Mismatch". The
value set by the criteria setting form is plugged into
controls on the main menu form, which is then pulled by a
Global function from the Main Menu and used as the
criteria for running reports. Here too, I keep getting
the: "Data Type Mismatch" error. So, it may that something
is falling out or not coming over correctly.

Any suggestion for solving this problem will be
appreciated.
 
The DateAdd function already returns a date type so using DateValue is
probably what is causing the problem. Just use
Date1:DateAdd("h",-7,[Date]). Also it is bad practice to use the name Date
to refer to an actual date, unless you mean the current date. If so you
should use Date() to clarify. Date1:DateAdd("h",-7,Date())

Kelvin
 
Back
Top