Convert Dynamics GP DEX_ROW_TS date value to local time using SQL – Apr 8, Dynamics GP Land

Back in 2014, the venerable Tim Wappat wrote an excellent blog post on the DEX_ROW_TS field that exists in some Dynamics GP tables.

http://www.timwappat.info/post/2014/12/04/Beware-DEX_ROW_TS-for-data-synchronisation

Occasionally, I have needed to check the TS field to see when...

Continued on Source: Dynamics GP Land: Convert Dynamics GP DEX_ROW_TS date value to local time using SQL