Newer Version Available

This content describes an older version of this product. View Latest

now()

Returns current datetime in the specified time zone. This function is valid only in a foreach statement.

Display the number of days an account is opened.

1q = foreach q generate Account, daysBetween('OrderDate', now()) as "daysOpened";