Re: Get time from DATE/time field?

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 16:14:45 -0400

Technically, that's a violation of database normalization principles, since
one field is totally derivable from another. What happens if someone updates
one field but not the other: which one's correct? 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"SR Bandy" <anonymous@discussions.microsoft.com> wrote in message
news:2f5001c48eca$aaa49fb0$a601280a@phx.gbl...
> This may not be the fix that you are needing - I got
> around this problem in a Business Call Center by storing
> both the Date/Time AND the Date (only) separately (both
> are entered as default value settings in table).
>
> This allows me to query by date and view exact date/time
> of transactions.
>
> Thanks, SR Bandy
>
> >-----Original Message-----
> >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
> >>
> >>
> >>.
> >>
> >.
> >

Relevant Pages

  • Re: Get time from DATE/time field?
    ... actually need to pull both out in different queries ... (poorly worded question). ... as from the looks of it the Int function only ... Thx again ...
    (microsoft.public.access.queries)
  • Re: Get time from DATE/time field?
    ... around this problem in a Business Call Center by storing ... This allows me to query by date and view exact date/time ... as from the looks of it the Int function only ... I'm hoping to pull out the correct values ...
    (microsoft.public.access.queries)