PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/02/2015 4:11 AM by  Chris Snape
S3 Query Wizard - UK
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Chris Snape
IT Manager
Private
New Member
(4 points)
New Member
Posts:2


Send Message:

--
07/01/2015 5:30 AM

    Hi all,

     

    New to the forum and Lawson.

     

    I am based in the UK with a lot of UK Locale PCs, which don't seem to like Date formats from our current version of the Lawson Query Wizard Add in. It keeps fetching the wrong date value into Excel for any US Date that can be read as a UK date. The rest it flips correctly. Causing me headaches to get it to stay consistent.

     

    I can convert the incoming column to Text, Number or Date and makes no difference. I figured that the Add in might be preset to US locale so I was wondering if a UK version exists that won't mess up the date extraction.

    Current version: Lawson S3 Add-Ins for Microsoft Office - Version 9.0.3.1387

     

    Any advice welcome. Thanks.

    Regards, Chris Snape
    Chris Snape
    IT Manager
    Private
    New Member
    (4 points)
    New Member
    Posts:2


    Send Message:

    --
    07/02/2015 4:11 AM
    For completion I have resolved this issue by using V10 of the Add-in and selecting 'System Settings' for the Default Date Format.
    Regards, Chris Snape
    You are not authorized to post a reply.