S3 Query Wizard - UK

Sort:
You are not authorized to post a reply.
Author
Messages
Chris Snape
New Member
Posts: 2
New Member

    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
    New Member
    Posts: 2
    New Member
      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.