Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Pass dates entered via date interface tool into filter

Highlighted
8 - Asteroid

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?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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,

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@craigja 

 

Something like this:

 

App1.PNGApp2.PNG

 

 

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

 

Cheers,

Highlighted
8 - Asteroid

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

Highlighted
7 - Meteor

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?

Labels