Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    287

    Unanswered: Convert 10.10.00 date to 10/10/00 date format

    I have fields with a format of 10.10.00
    but when i attenmpt to convert them to dates it errors and says that it will delete them. I assume I have to do something the excel end (source) as it is a form that when changed to date format still shows 10.10.00 rather than the select 10/10/00

    Any help on how I can do this via Excel or Access - even if it means using a formula in Excel to convert the dates?

    Thanks.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    This is getting to be very aggravating! I posted an answer to this thread a while ago, as did someone else. Came back to check it and both responses are gone. Checked, and the question wasn't double posted. This is not the first time this has happened. Where do you report problems?

    In VBA code:

    Format(CDate(Replace(StringDate, ".", "/")), "dd/mm/yy")

    or in a Query

    ConvertedField: Format(CDate(Replace(StringDate, ".", "/")), "dd/mm/yy")
    Last edited by Missinglinq; 04-20-09 at 13:19.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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