Get the the records within past 3 months

[eyalj]

Hey,

I'm Using react and I'm searching for a way that i can query the last records withing the last 3 month.

i don't want to use an assistant function and want to use only the arguments or where clause

i tried to do 

where = 'Date >= DATEADD(DAY, -90, GETDATE())'

but it didn't work 

is anyone now how can I do it? is it even possible?

[UndralBatsukh · Accepted solution]

Hi there, 

You should be able to use INTERVAL function. You may find this blog useful: https://www.esri.com/arcgis-blog/products/api-rest/data-management/querying-feature-services-date-ti...