Change date

[Pedro87]

Good morning, I present the following query

I present a workflow where the field called “FEC_DUE” is of type date with the structure YYYY-MM-DD, where YYYY is the year, MM is the month and DD is the day.

What I need is that for the “FEC_VENCIMIENTO” field where the date 2022-10-31 appears, it is replaced by the date 2022-09-30. I tried to do it with node (modify date) without success.

Attached:
Data
screen print

Part of the workflow

Node - Modify date

Base.xlsx (215.7 KB)

Data sample

[Daniel_Weikert]

You could use Date&time shift node
br

[Pedro87]

Hello @Daniel_Weikert, good afternoon. Could you guide me with screen printing of what options I should enter in the node called “date&time shift” to replace the date from 2022-10-31 to 2022-09-30

[Daniel_Weikert]

you probably want to use replace instead of append
br

[Pedro87]

Thank you very much @Daniel_Weikert for the help