Re: Linking date data types in a query
- From: "David Lloyd" <David@xxxxxxxxxxxxxxxx>
- Date: Fri, 4 Nov 2005 20:29:08 -0500
I do not have all the specifics of what you are trying to accomplish,
however, if your goal is to just compare the date portion of two dates
without the time value, you can use the Int function. In date values, the
time is represented by the fractional value of the date. Therefore, to
remove the time component (actually just make it the same for all dates),
just round the date to a whole number. For example:
Int(MyFirstDate) = Int(MySecondDate)
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"Parts Maker" <PartsMaker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A02892BC-5FAA-480B-A170-F8E2E403428B@xxxxxxxxxxxxxxxx
I tried linking date data types in a simple query and it does not seem to
work. The date data types are the same format (short - mm/dd/yyyy). It
seems
like the data type may include the hh:mm:ss that you can't see and unless
you
have the exact value, down to the second, the query will not return what you
are expecting. Let me know if there is a way to get it to work. Thanks
much!
.
- Prev by Date: Re: Count
- Next by Date: Re: Decatenate a field with Make Table Query?
- Previous by thread: Limit query results/records?
- Next by thread: Re: Decatenate a field with Make Table Query?
- Index(es):
Relevant Pages
|
