Filter options for dates in arcgis online features

Idea created by damoneisenach on Jan 27, 2016
    • dolbik
    • vscott1
    • damoneisenach
    • maphew

    I would like to filter dates based off 'anything in the last week' or 'anything in the last month' rather then choosing a static date that i have to go back and update.
    It would be helpfull if i could do what i can do inside of a definition query in arcmap.
    I would really like to be able to say show me where CreationDate is between 1 day and 30 days ago or show me 7 to 14 days ago. so I dont have to update the filter constantly for those using maps in the field to only see recent edits/data.
    CURRENT_DATE - "date_field" > 1
    DATEDIFF(d, [DateField], GETDATE()) <= 30 AND NOT [DateField] > GETDATE()
    transdate between dateadd(day,-90,getdate() ) and getdate()
    changedate between dateadd(day,-14,getdate() ) and getdate()-7