none
oData Syntax for Now() RRS feed

  • Question

  • Hi

    I am wondering if it is possible to incorporate the Now() function in an oData statement.  If so, what would the oData command look like.  Ultimately, I am wondering how to write the $filter=... so that I capture date fields for data that is a few days in the past, or a few days in the future.

    Any help greatly appreicated


    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Sunday, November 2, 2014 6:09 PM

Answers

All replies

  • Hello,

    Project Online uses Odata v3 which doesn't have the Now() function available, this was introduced in OData v4 which Project Online doesn't use. If using Power Query you can use the date.now function with OData queries.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS


    Sunday, November 2, 2014 6:19 PM
    Moderator
  • Darn!  I was hoping to be able to use somethingly like "now" to help me optimize my filtering of data from Project Server Online's projectdata(base).  I guess that means that I will have to update my querries more often than I would like to.

    Is there any word on when oData v4 will be available for Project Server Online?


    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Friday, November 7, 2014 6:00 PM
  • Hello, last time I asked about v4 ODATA for Project Online there were no plans to move from v3. Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Saturday, November 8, 2014 7:35 AM
    Moderator