In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Issues with Formula

robin0905
5 - Atom

Hi can anyone assist, I've been trying to create a formula using the formula tool, as seen below but keep getting 'not wrong' regardless of whether the criteria is met:

 

any idea to what I'm doing wrong?

 

if [Date] and [End Date] <= [open date] THEN "right" else "non wrong" endif

 

Thanks

7 REPLIES 7
OTrieger
13 - Pulsar

@robin0905 
It is hard to know just from your post.

What is the data type of all 3 date fields

Bren_Spill
12 - Quasar
12 - Quasar

@robin0905: try: if [Date] <= [open date] and [End Date] <= [open date] THEN "right" else "non wrong" endif

 

Also you're data types all need to match up as @OTrieger said

OTrieger
13 - Pulsar

@Bren_Spill  it will work only if all will be Date data type, as if they will all be sting that would not work as expected.

Bren_Spill
12 - Quasar
12 - Quasar

@OTrieger agreed - that's why I referenced your post in mine!

OTrieger
13 - Pulsar

😎

 

robin0905
5 - Atom

Thanks Bren and all ... solution worked really well for me... very new to Alteryx - help much appreciated! 

Bren_Spill
12 - Quasar
12 - Quasar

@robin0905 - no problem! Can you mark as solution so it makes it easier for others to find? (you can mark two as solution!)

Labels
Top Solution Authors