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.