Issues with Formula

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

Common Use Cases

Accepted answers

Bren_Spill2

@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

All comments

OTrieger

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

What is the data type of all 3 date fields

Bren_Spill2

@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

@Bren_Spill2 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_Spill2

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

OTrieger

😎

robin0905

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

Bren_Spill2

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703