now()

Returns the current datetime in UTC. This function is only valid in a foreach statement.

now()

This function is commonly used with daysBetween(​), date_diff(​), and date_to_string().

How long ago was each opportunity created, in weeks? Use date_diff(), datepart = week, and now().

What is the date today? Use now() inside date_to_string().

See Also

• date_diff()
• now()