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>]