# 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.

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

**See Also**

- [now()](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-date-now.md)