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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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