Get the last month data in odata services

See more:

SQL

MS-Excel

OData

Hello everybody,

I'd been trying to find a way to get the info from the last month on of an OData Feed. I know how to get it if a write the specific date but I need the expression to detect by itself the last month of the actual month we are.

What I have tried:

So far I have this (...)/pwa/_api/projectdata/AssignmentTimephasedDataSet?$filter=TimeByDay ge datetime'2016-10-01' , but the last month I have to put it manually and I need an expression that calculate the last month by itself. Any suggestion if this is possible?

Regards,
Pablo