Date change based on an expired code.

[Luk88kk]

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

[abe_ibanez]

Hello, 

Could you please post a screenshot or upload a copy of your current workflow? 

Thank you, 

[Luk88kk]

Hi,

This is what I am trying to do.

[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. 

So, for me to get it to work on my machine, I had to update the formula to: IF [Number] = "1234" THEN "2024-07-01" ELSE [Date] ENDIF. 

Hope this helps

[abe_ibanez · Accepted solution]

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. 

So, for me to get it to work on my machine, I had to update the formula to: IF [Number] = "1234" THEN "2024-07-01" ELSE [Date] ENDIF. 

Hope this helps

[Luk88kk]

Hi,

Thank you very much for the hint, it works great.

Have a nice day