Returns the number of days between two dates as an integer.
For example, display the number of days to close a deal. OpenDate and CloseDate fields can be DateTime or DateOnly.
q = foreach q generate daysBetween('OpenDate','CloseDate') as "Days to Close";
See Also