Prev
Next
Forums Lawson Add-Ins for Microsoft Office

Query brings back dates, but excel 2010 displays as a number

Sort:
You are not authorized to post a reply.
Author
Messages


Terrie











Basic Member



Posts: 4




Basic Member



7/13/2012 1:11 PM
    We were on Windows XP, Office 2010, and when I did a query, it brought back the data in excel and displayed correctly.  We recently upgraded laptops to Windows 7.  Now when I do same query, it brings back data and displays dates as number.

    It only does this for me.  It doesn't do that on another person laptop who was give Windows 7.

    Has anybody seen or experienced this?  Any suggestions on what I can do to stop this?

    Thanks


    JimY











    Veteran Member



    Posts: 510




    Veteran Member



    7/20/2012 10:43 AM
      I have had that problem with other apps that extract dates. What I had to do to correct it was to format the cell as a date. That changed the number to a date. Good luck.


      BarbR











      Veteran Member



      Posts: 306




      Veteran Member



      7/20/2012 10:52 AM
        This same problem arose for us after we applied an upgrade. I don't remember the details, but Lawson has a patch for this and after we applied the patch the problem went away.


        BarbR











        Veteran Member



        Posts: 306




        Veteran Member



        7/20/2012 10:54 AM
          I should have said that it was an Add-In patch - so you'll need to upgrade the clients (we are using MOA_09000301P11491 which does not have this problem.


          Terrie











          Basic Member



          Posts: 4




          Basic Member



          7/25/2012 5:37 PM
            Thank you for the reply.  I will pass this information on to our IT staff.
            You are not authorized to post a reply.