Formula Date Range

Struggling to crack the below formula.

I need to replace a cell with the correct season by implementing a date range formula below:

IF [SO Type Desc]="Cust At-OnceCall-off" AND [CRD Dt]>="19.03.2019" and [CRD Dt]<="31.03.2019" THEN "SU19" ELSE [Season] ENDIF

The formula doesnt above doesnt seem to work as i believe its looking at anything greater than the 19.03.2019 separately to anything less than the 31.03.2019 meaning its replacing all the cells with SU19 when i only want it to change cells which has a date between the 19.03.2019 - 31.03.2019

Any help would be great (work flow attached)

thanks

ozzy

QS TEST (ALTERYX).xlsx

Topic of Interest

Accepted answers

RobertOdera

Hi there!

Try and use Alteryx syntax for date format "YYYY-MM-DD" like so using Multi-Field Formula Tool:

In the tool, Select Text Fields = Season, unchecked Copy Output Fields Add, unchecked Change Output Type to, paste the below in the Expression

IF [SO Type Desc] ="Cust At-OnceCall-off" AND
[CRD Dt] >="2019-03-19" AND
[CRD Dt]<="2019-03-31"
THEN "SU19" ELSE [_CurrentField_] ENDIF

Where _CurrentField_ == [Season]

Please see attachment; hopefully this works for you.

FYI you will need to connect your file to the input on the attachment.

FYI the Filter tool used for validation purposes only...feel free to remove it once you confirm that the output is what you need.

FormulaDateRange.yxmd

All comments

RobertOdera

Hi there!

Try and use Alteryx syntax for date format "YYYY-MM-DD" like so using Multi-Field Formula Tool:

In the tool, Select Text Fields = Season, unchecked Copy Output Fields Add, unchecked Change Output Type to, paste the below in the Expression

IF [SO Type Desc] ="Cust At-OnceCall-off" AND
[CRD Dt] >="2019-03-19" AND
[CRD Dt]<="2019-03-31"
THEN "SU19" ELSE [_CurrentField_] ENDIF

Where _CurrentField_ == [Season]

Please see attachment; hopefully this works for you.

FYI you will need to connect your file to the input on the attachment.

FYI the Filter tool used for validation purposes only...feel free to remove it once you confirm that the output is what you need.

FormulaDateRange.yxmd

ozzy78910

Thank you very much that has solved my issues!

Have a great day

Thanks

ozzy

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703