Pass dates entered via date interface tool into filter

[craigja]

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?

[Thableaus]

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,

[Thableaus · Accepted solution]

@craigja 

Something like this:

You need to replace the date strings in your expression, according to Start Date and End Date logic.

Cheers,

[dexter90]

I am doing something very similar,however if nothing is selected by the user,how to filter based on default values?

[S-9]

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?