How to Find the Difference Between Two Time Fields in an Extender Calculated Field

In this video, we walk through how to find the difference between two time fields in an extender calculated field. We'll see why a straightforward subtraction between two datetime fields fails and how Extender’s use of SQL temp tables shows us the SQL datatype conversion error behind the scenes. You'll learn how to identify the issue using the GP DexSQL.log and see exactly what’s happening at the SQL level when Extender tries to calculate the time difference. If you'd like to read the help article that goes along with this, click here.