Results 1 to 3 of 3
  1. #1
    Freebird is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    2

    Problem exporting dates to Excel

    I have an issue with dates in Excel, which is driving me loopy.



    We have a database which records all our projects, that has been in use for a long time. We have various queries which are created from the database and exported to Excel using macros and these have been working fine until now.

    I've been issued with a new laptop as my old one was dead, and now when I run the queries, if I try to sort by date then the result is wrong and looks like it's in US format (mm/dd) except it doesn't error when it hits 13. So I suspect it's actually being output as text rather than a date.

    Nobody else is affected. They can sort as they always have, so it has to be something on my new setup, but i don't know what. I've gone through user settings for date, region, etc and they're all ok. Nothing has changed with the database or any of our queries/macros, and if somebody else runs a report and forwards it to me, I can sort it as normal.

    We had something similar a couple of years back when somebody had a new PC, but can't for the life of me remember how we solved it.

    Thanks for any help

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you are sorting by date, you need 2:
    1 to view date normally,
    1 to sort by, either yymmdd, or numerically.

  3. #3
    Freebird is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    2
    Thanks for the response, but I think I explained the problem badly. It wasn't Excel that was the problem, but the fact that Access was exporting dates as text.
    I've experimented with a backup copy and found that if I remove the input mask from date fields in the database back-end tables, then it exports dates as dates.
    What is still puzzling me is why it only affected me, when we all use the same front-end and back-end for the database i.e. why did dates come out as text for me, but came out as dates for them?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Problem Exporting Multivalued Field to Excel
    By MatthewR in forum Queries
    Replies: 16
    Last Post: 02-11-2016, 02:14 PM
  2. Problem exporting multi-line addresses to Excel
    By mjwillyone in forum Import/Export Data
    Replies: 4
    Last Post: 01-27-2016, 11:01 AM
  3. Exporting a Table to MS Excel problem
    By nosec in forum Import/Export Data
    Replies: 9
    Last Post: 11-05-2013, 11:28 AM
  4. Replies: 1
    Last Post: 10-19-2011, 07:51 PM
  5. Exporting to Excel Problem
    By octu in forum Import/Export Data
    Replies: 1
    Last Post: 04-14-2010, 11:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums