Issues with Formula

[robin0905]

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

[OTrieger]

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

What is the data type of all 3 date fields

[Bren_Spill2 · Accepted solution]

@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!)