FluentPro Help Center

What do you need help with?

Using Current Date and Timeline Dates

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}


Was this article helpful?

Table of contents

    Back To Top