Re: Text to Date(MM/DD/YY) Conversion

From: Jayshree (anonymous_at_discussions.microsoft.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 05:05:51 -0700

Thanks for great help, it works
thanks again
>-----Original Message-----
>You should be able to use the CDate function to convert
the text date to a
>real date. If that fails, you can parse the date into the
year, month and
>day and use DateSerial to convert it: DateSerial(Mid
(TextDate, 7),
>Left(TextDate, 2), Mid(TextDate, 4, 2))
>
>Once you've got them as dates, you can use DateDiff to
compare them.
>
>--
>Doug Steele, Microsoft Access MVP
>http://I.Am/DougSteele
>(no e-mails, please!)
>
>
>
>"Jayshreeb" <anonymous@discussions.microsoft.com> wrote
in message
>news:56ce01c49185$fb6d78f0$a301280a@phx.gbl...
>> In my Access database, I have one "TEXT" field which
>> contains date in "mm/dd/yy" format & now
>> 1> I want to convert the Text data in actual Date
>> (MM/DD/YY) format
>> 2> I want to find the difference between the two dates
>> Thanks
>> Jayshree
>
>
>.
>

Relevant Pages

  • Re: csv parse bug...
    ... > module bug, pl excuse me. ... > I am facing an odd bug when using parse() function in Text::CSV ... This is an absolutely textbook use of the function which fails ... > possible fields which will have embedded commas qualified by double ...
    (comp.lang.perl.misc)
  • Re: require and the site_ruby directory...
    ... Just Another Victim of the Ambient Morality wrote: ... One way that it is defective is that it can't always parse the links of a page. ... The strange thing is that it works find for some pages but completely fails for others. ... I have yet to run into public Ruby libraries which require you to copy them into the Ruby directory. ...
    (comp.lang.ruby)
  • csv parse bug...
    ... module bug, pl excuse me. ... I am facing an odd bug when using parse() function in Text::CSV module. ... This is an absolutely textbook use of the function which fails for some ... possible fields which will have embedded commas qualified by double ...
    (comp.lang.perl.misc)
  • reviewing Hacmp.out files
    ... I need a way to parse ... hacmp.out files on 2 node cluster why every week the ... node b fails to bring all resources back. ... HP-UX System Administration Certified ...
    (AIX-L)
  • Re: Change string to date
    ... "Phil Hunt" wrote in ... > Is there a CDATE function in access. ... Yes, there is, but it won't parse a completely invalid date format like ... Tim F ...
    (microsoft.public.access.modulesdaovba)