community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Error Messages in Interface Tools with Dates

Highlighted
Quasar

I have an app that allows users to query a SQL Database. The user is permitted to enter start and end dates (as well as other criteria). The particular table I point to only includes current year data so I want to restrict the user to only select dates in the current year.

 

With this formula, I get an invalid type in operator message:

[#1]>2016-12-31

 

This formula does not restrict the date:

[#1]>'1-january-2017'

 

What is the right formula for this use case?

Capture.PNG

 

 

Alteryx Certified Partner
Alteryx Certified Partner

@ddiesel,

 

Hi :)

 

'2016-12-31' represents a STRING.  All dates are STRINGS.

 

[#1] > "2017-01-01"

Try that please.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Quasar

Hello! @MarqueeCrew... fastest draw in the galaxy!

 

Configuration:

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Error message:

Capture.PNG

 

 

Alteryx Certified Partner
Alteryx Certified Partner

https://meetings.webex.com/collabs/meetings/join?uuid=MBK0HP925LDF6B3CPY90DGIBP5-UCSL&epwd=fde19b0a0...

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Certified Partner
Alteryx Certified Partner

to find this year,

 

Left([#1],4) != '2017'

 

That will error for other years.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Quasar

Solution from @MarqueeCrew

 

Left([#1],4) != "2017"

 

Thank you!

Labels