The solution is here fabs(Date(Field1,'DD/MM/YYYY')) - fabs(Date(Field2,'DD/MM/YYYY')) For ex: LOAD orderDate, desDate, delDate, fabs(Date(desDate,'DD/MM/YYYY')) - fabs(Date(orderDate,'DD/MM/YYYY')) as orderDespatchGap, fabs(Date(delDate,'DD/MM/YYYY')) - fabs(Date(orderDate,'DD/MM/YYYY')) as leadTime, fabs(Date(delDate,'DD/MM/YYYY')) - fabs(Date(desDate,'DD/MM/YYYY')) as despatchDeliveryGap FROM [<DATA LOCATION>]