Hello, I would like to change the validity dates for the individual codes, but something is not working. In the column "Number" I have the product codes. And for code 1234 I need to set new expiry dates - 01.07.2024 + UPD in a separate column "Status". I have tried, but something is not working... I get a date of 1899-12-30... Could you please help me with this. How it is: NumberDateStatus123408.03.2023 765809.02.2021 796710.02.2021 123411.06.2028 981519.01.2021 324515.10.2023 123414.02.2021 740225.06.2022 How it should look: NumberDateStatus123401.07.2024UPD765809.02.2021 796710.02.2021 123401.07.2024UPD981519.01.2021 324515.10.2023 123401.07.2024UPD740225.06.2022 Test.xlsx

Date change based on an expired code.

Hello,

I would like to change the validity dates for the individual codes, but something is not working.
In the column "Number" I have the product codes. And for code 1234 I need to set new expiry dates - 01.07.2024 + UPD in a separate column "Status".

I have tried, but something is not working... I get a date of 1899-12-30...

Could you please help me with this.

How it is:

Number	Date	Status
1234	08.03.2023
7658	09.02.2021
7967	10.02.2021
1234	11.06.2028
9815	19.01.2021
3245	15.10.2023
1234	14.02.2021
7402	25.06.2022

How it should look:

Number	Date	Status
1234	01.07.2024	UPD
7658	09.02.2021
7967	10.02.2021
1234	01.07.2024	UPD
9815	19.01.2021
3245	15.10.2023
1234	01.07.2024	UPD
7402	25.06.2022

Test.xlsx

Datasets

Accepted answers

abe_ibanez

Thank you for posting the test workflow.

The issue is with your formula tool. The tool is already replacing the value in "Date", so the formula does not need to have [Date] = "01.07.2024" . It should just be IF [Number] = "1234" THEN "01.07.2024" ELSE [Date] ENDIF

Also, since the "Date" field is coming in as Data type: Date, you must use the default date format for Alteryx. Not sure if you have it set up where dates are formatted as dd.MM.yyyy. Normally, Alteryx formats dates as yyyy-MM-dd.