Free Trial

Alteryx Designer Desktop Discussions

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

Formula

jlfromm
8 - Asteroid

what formula I do  write for the following 

 

I have several different dates and if it fall between a certain date I want it to display contract 1 number  in the  Contract Column if  it between another date I want it to display contract 2 in the  Contract Column. Below is just a mock 

 

jlfromm_0-1683554672114.png

 

 

Contract 1 number is anything dates between 06/01/2019-05/31/2023  & Contract 2 is any dates between 06/01/23-05/31/25  

1 REPLY 1
binuacs
21 - Polaris

@jlfromm One way of doing this

binuacs_0-1683576137120.png

 

Labels
Top Solution Authors