Re: Format Date

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 05/30/04 

Date: Sun, 30 May 2004 09:28:07 -0700

Tiffany

What is the underlying structure of the "date field"? You describe it as a
"general number", but is it a number like Access uses, or is it a text
string like "20040530"?

Access has a DateSerial(Y,M,D) function you could check into using (try HELP
on DateSerial). 

-- 
Good luck
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: How to eliminate space when field has null value in text string?
    ... Good luck ... Jeff Boyce ... <Access MVP> ... > Some of the fields in my text string will be blank - can I design it such ...
    (microsoft.public.access.reports)
  • Re: Count nulls in report
    ... I tested something this morning and came up with the following SQL statement ... that generated the string "" when the field held null. ... Jeff Boyce ... <Access MVP> ...
    (microsoft.public.access.reports)
  • Re: Go to a control after an error
    ... You didn't mention which event firing you used to run this code -- ?in the ... Or a text string? ... Jeff Boyce ... <Access MVP> ...
    (microsoft.public.access.forms)
  • Re: Extracting Initials
    ... Conceptually, if you take that last string, from which you derive the "A.", ... and look to the right of the space following "Anne", ... Jeff Boyce ... <Access MVP> ...
    (microsoft.public.access.queries)