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";