CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. January 24th, 2006, 10:49 AM #1
    canton
    canton is offline Junior Member
    Join Date
    Oct 2005
    Posts
    20

    MS Access Parsing Date

    Hi,

    I have field in an Access database whose datatype is text.

    It contains various dates, some of which are in Y-MM-DD (e.g. 20011231), while the rest are only in Year format (e.g. 1999).

    How can I modify this field so that the dates in Year format (such as 1999) are converted to Year(as specified in field)Jan1 (e.g. 19990101). So that the format for the field is either Y-MM-DD or some numeric format (such as double)

    Thanks,
    Reply With Quote Reply With Quote
  2. February 7th, 2006, 02:07 PM #2
    womalley
    womalley is offline Member
    Join Date
    May 2003
    Location
    upstate NY
    Posts
    168

    Re: MS Access Parsing Date

    maybe this site can help ya out

    MS ACCESS
    --------------------------------------------
    Tell me and I will forget
    Show me and I will remember
    Teach me and I will learn
    Reply With Quote Reply With Quote
  3. February 8th, 2006, 01:28 PM #3
    Rich2189
    Rich2189 is offline Member +
    Join Date
    Oct 2005
    Location
    England
    Posts
    803

    Re: MS Access Parsing Date

    try

    Code:
    SERIAL = format(date, "general number")
    This will convert a date into a date serial, date number 1 is january the 1st 1989 (i think) and they have been numbered like that ever since. Today we are on something like 36000.


    then to get the date back

    Code:
    cDate(serial)
    Rich
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured