Report filter by dynamic date
Im trying to create a report for a Dashboard and I want it to display Workstations that have value in "Warranty Expiry" that has been passed.
So when creating my Report i'm looking for a comparison that says "less than today" where today is a dynamic field that uses a "get_date" function.
But if I select "less than" I have to select a date in a picker. Looking at the SQL queries it looks like a pretty hard coded value and dosen't give me what Im looking for. I want a dynamic report that shows different result depending on wich day Im logged in at. Is there a way to do this?
Then I try to create a custom query using sequal functions as date_part or extract but those doesn't seem to work either..
(platform is running on Postgre SQL)
New to ADSelfService Plus?