Date Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a program that enters the date/time someone enters data into the
database. I then need to be able to pull a report based on just the date
section. I have created a paramater query with the * at the end of the date
so it will pick up the time as long as you enter the date however I never get
any results. The date and time is in the table as Date/Time and the Default
Value is (Now()) in the Query under the Date field I have the following
paramter Like [Enter the Date:]&"*"
 
Change your field expression to something like:

UnnamedDateOnly: DateValue([UnNamedDateField])

[Enter the Date]
 
This does not seem to work either.

Duane Hookom said:
Change your field expression to something like:

UnnamedDateOnly: DateValue([UnNamedDateField])

[Enter the Date]

--
Duane Hookom
MS Access MVP
--

Michelle said:
I have a program that enters the date/time someone enters data into the
database. I then need to be able to pull a report based on just the date
section. I have created a paramater query with the * at the end of the
date
so it will pick up the time as long as you enter the date however I never
get
any results. The date and time is in the table as Date/Time and the
Default
Value is (Now()) in the Query under the Date field I have the following
paramter Like [Enter the Date:]&"*"
Click to expand...
Click to expand...
 
This worked for me. However, I had to enter the date as mm/dd/yyyy. I
changed the first part to - UnnamedDateOnly: Format([UnNamedDateField],
"m/d/yy") and now I can enter the date in that format.

Duane Hookom said:
Change your field expression to something like:

UnnamedDateOnly: DateValue([UnNamedDateField])

[Enter the Date]

--
Duane Hookom
MS Access MVP
--

Michelle said:
I have a program that enters the date/time someone enters data into the
database. I then need to be able to pull a report based on just the date
section. I have created a paramater query with the * at the end of the
date
so it will pick up the time as long as you enter the date however I never
get
any results. The date and time is in the table as Date/Time and the
Default
Value is (Now()) in the Query under the Date field I have the following
paramter Like [Enter the Date:]&"*"
Click to expand...
Click to expand...
 
Back
Top