Change date

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.

screen print

Part of the workflow

Node - Modify date

Base.xlsx (215.7 KB)

Data sample

You could use Date&time shift node

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

you probably want to use replace instead of append


Thank you very much @Daniel_Weikert for the help

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.