|
|
||||||
|
#1
09-16-05, 02:28 PM
|
|
|
|
|
Access 2K/Win2K. Field has date/time data type. Data is only date - no time
included. Using the criteria: between date()-1 and date() but getting error: Data type mismatch. Any suggestions? |
|
|
|
#2
09-16-05, 03:26 PM
|
|
|
|
|
What happens if you use the actual dates (Between #9/15/2005# And
#9/16/2005#) as the criteria? Regards Jeff Boyce <Access MVP> "maryj" <maryj> wrote in message news:d084 [..] |
|
#3
09-23-05, 01:26 PM
|
|
|
|
|
Needed to create a new field using the Datevaule function. Then the criteria
worked on the new field. |
|
|
| Similar Threads | |
| Today and yesterday Can you tell me which the most simple method to get today´s date and yesterday´s date in solaris and red hat ? |
|
| yesterday, today, tomorrow user friendly dates, possible? Hi, Is it possible to display dates as yesterday, today or tomorrow instead of numeric dates in a list view? Thanks. |
|
| RDP-Yesterday Yes, Today No "The specified remote computer could not be found" when I attempt RDP connection to office PC. Office PC behind Netgear router, Windows Firewall deactivated, Norton Internet... |
|
| Getting Dates - today, yesterday help Our order dates field looks like this: 2007-01-01 11:11:43.000 If I just wanted to do a Select on orders today or between a date range, is there a simple way? Instead of... |
|
| Today and Yesterday TableA has a listing of several companies that are imported daily. How would I set the cirtieria of of tableA.date in a query to show me all the companies that have a date... |
|
|
All times are GMT. The time now is 01:38 AM. | Privacy Policy
|
criteria for dates for yesterday and today