• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

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

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
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.
Deleted User
New Member
Posts: 0
New 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.
Deleted User
New Member
Posts: 0
New 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.