Re: us date format

"Bob Wickham" <wickham_bob@xxxxxxxxxxxx> wrote in message
news:43d2e2ef@xxxxxxxxxxxxxxxxxxxx
>
> The "Steve" suggestion I was referring to was in response to a question
> asked by you back in October (Steves reply below).
>
> I am wondering if there is a right/wrong or good/bad way to do it or is
> like the "discussions" I have with my father-in-law about the pros and
> cons of PC's and Mac. ie. It depends on what you need.

Whichever way gives you the correct answer is the "right" way. <g>

Take a look at the discussion I had with Marsh elsewhere in this thread. I
don't see that one approach is better than the other. Yes, the CLng approach
assumes that dates are stored as numbers, and if that ever changed then this
wouldn't work, but I can't see such a fundamental thing changing.

Personally, I always use the Format approach (Format(MyDate,
"\#mm\/dd\/yyyy\#") rather than the CLng approach, but I would think that
one function call is just as "expensive" as the other. It's possible that
the CLng approach is actually slight more efficient, since Access has to
convert the string version of the date returned by the Format function to a
date.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)



.

Relevant Pages

  • Re: Calendar and time sheet
    ... So show me how you'd generate SQL you'd use to retrieve the value from your ... denormalized table in the circumstance you just suggested, Steve. ... >> as vbSunday, vbMonday, ?, vbSaturday) and WhatWeekdayOfMonth is the order ... >> Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Advatages of database over text file storage
    ... Steve. ... Dave Hargis, Microsoft Access MVP ... How does disk storage space for an Access file compare with a ... but the Excel file used to store raw data presently occupies 3.1 MB. ...
    (microsoft.public.access.gettingstarted)
  • Re: Converting date entry from mm/dd to mm/yy
    ... Warm Regards, ... Microsoft Access MVP 2006 ... Thank you Steve and Crystal. ... Access stores date/times in a numeric format where the integer portion of the number represents the date and the decimal portion of the number represents time: ...
    (microsoft.public.access.formscoding)
  • Re: reservation chart in access
    ... Duane Hookom ... Microsoft Access MVP ... "Steve" wrote: ... If this thread were to stay on topic with the required chart and the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ocx vs dll
    ... "Steve Conway" wrote in message ... >> Doug Steele, Microsoft Access MVP ... >> (no e-mails, please!) ...
    (microsoft.public.access.formscoding)
Loading