254 shaares
1 result
tagged
now
In views, you’ll need to set filters using [Today]
You could also create more complicated filters such as:
* Incomplete projects: DueDate <= [Today] AND Completed=No
* Projects beginning in a week or more: StartDate >= ([Today]+7)
* Last year on this day: Created = [Today]-365
In calculated columns, you’ll need to use Today() or Now() as the value for today’s date or today’s date and time.
The difference is Now() uses date and time, so you’ll get down-to-the-minute values (i.e. hours since reported). Today is just date best used for data with no times involved (i.e. days since hire date).
You could also create more complicated filters such as:
* Incomplete projects: DueDate <= [Today] AND Completed=No
* Projects beginning in a week or more: StartDate >= ([Today]+7)
* Last year on this day: Created = [Today]-365
In calculated columns, you’ll need to use Today() or Now() as the value for today’s date or today’s date and time.
The difference is Now() uses date and time, so you’ll get down-to-the-minute values (i.e. hours since reported). Today is just date best used for data with no times involved (i.e. days since hire date).