Current Date
SharePoint pack widgets provide a possibility to use current date\time in OData queries. Current date\time can be reffered via {Now} or {Now<+\-offset>} tags. {Now} tag will be substituted with current UTC date\time, {Now<+\-offset>} tag will be substituted with UTC +\- specified offset (e.g. {Now+2} or {Now-1}).
For example, to display overdue issues use the following query:
Issues?$filter=DueDate lt {Now}or, in case you want to use time shifted by some offset comparing to UTC (e.g. to match your local time), use:
Issues?$filter=DueDate lt {Now+2}Timeline Dates
SharePoint pack widgets provide a possibility to use Start Date and End Date selected on the Timeline in OData queries. These dates can be referred via {StartDate} and {EndDate} tags.
For example, to display issues where due date falls into period selected in the Timeline use the following query:
Issues?$filter=DueDate ge {StartDate} and DueDate le {EndDate}