Property TODAY()

 

Description
Returns the current date based on the browser’s system date.

Parameters
None

Return Value
DATE or NUMBER

 

Examples

Formula

TODAY()

Result
Returns the current date

Formula

TODAY() - lastedited

Result
Returns number of days since last edit

Formula

ROUNDDOWN(((start - DATE(2019,12,11)) / 7) - ROUNDDOWN((TODAY() - DATE(2019,12,11)) / 7))

Result
Returns relative week position (0 = this week, <0 = past, >0 = future)

Notes

• Based on browser/system date
• Useful for time comparisons and calculations