Hi,
I have 2 date pickers that I use to pick a start and end date - how do I pass these dates into the filter tool so that it can use them?
Solved! Go to Solution.
Hi @craigja
Use Custom Filter option - It allows you to compare multiple fields (you just need to reference these field names).
Example: [Start date] < [End Date]
EDIT: I think I get your question (by the title of topic)
I'd put general dates (like '2015-01-01') in your filter expression and update value with Action Tool, using both date interface tools.
Cheers,
Something like this:
You need to replace the date strings in your expression, according to Start Date and End Date logic.
Cheers,
I am doing something very similar,however if nothing is selected by the user,how to filter based on default values?
this works great on the filter, but not when i use the date interface tools inside an input to change the constraints inside my query using update action with formula:
i use the same query and replace the dates with [#1] for the date
I use an oracle database and it throws out this error: ora-01841 (full) year must be between -4712 and +9999, and not be 0 error
the query itself runs fine without any errors.
not sure what is causing this, any thoughts?