Re: Get time from DATE/time field?
anonymous_at_discussions.microsoft.com
Date: 08/30/04
- Next message: Shanin: "Re: query help"
- Previous message: Michael S. Montoya: "SQL help"
- In reply to: Douglas J. Steele: "Re: Get time from DATE/time field?"
- Next in thread: SR Bandy: "Re: Get time from DATE/time field?"
- Reply: SR Bandy: "Re: Get time from DATE/time field?"
- Reply: Douglas J. Steele: "Re: Get time from DATE/time field?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 12:09:14 -0700
Sorry, actually need to pull both out in different queries
(poorly worded question). Was hoping you might give me an
example, as from the looks of it the Int function only
looks like it will allow you to limit the storage the
fields contain. I'm hoping to pull out the correct values
out from a field with only entering the date (not the time)
When I do it now, because I don't ask for the time, it
returns nothing. Make sense?
Any time for a quicky example perhaps?
Thx again
>-----Original Message-----
>Your subject says "Get time", while the body of the post
says "just the
>date", so I'll give you both.
>
>To get the Date from a Date/Time field, use the DateValue
function (or the
>Int function). To get the time, use the TimeValue
function.
>
>--
>Doug Steele, Microsoft Access MVP
>http://I.Am/DougSteele
>(no e-mails, please!)
>
>
>
>"Anon" <anonymous@discussions.microsoft.com> wrote in
message
>news:2e6101c48ebe$51dc2990$a601280a@phx.gbl...
>> Hi Everyone,
>> Stupid question here, but does anyone know how to get
just
>> the date out of a date time field? All of the examples
>> lean toward DD, or MM, but I can't locate anything on
all.
>> Field is currently:
>>
>> 12/01/04 12:24:02
>> DD/MM/YY HH:MM:SS
>>
>> I just want to find the ones with date like "04/03/04"
for
>> example...
>>
>> Thx in advance,
>>
>> Nine Doors
>
>
>.
>
- Next message: Shanin: "Re: query help"
- Previous message: Michael S. Montoya: "SQL help"
- In reply to: Douglas J. Steele: "Re: Get time from DATE/time field?"
- Next in thread: SR Bandy: "Re: Get time from DATE/time field?"
- Reply: SR Bandy: "Re: Get time from DATE/time field?"
- Reply: Douglas J. Steele: "Re: Get time from DATE/time field?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
