Manipulation of Date variable


I have a little question please:

I have a two Date variable in this format 2018-07-20 and 2017-12-20, i used Extract Date&Time Fields to extract Year And Month. I have in Output : month: 7 / Year : 2018 / month : 12 / Year : 2017
But, in my workflow i need that the month will be 07 & 12.

What I can do please ?


instead of Extract Year and Month node you can use String Manipulation (or Column Expressions) node with function substr and get format you wish. Before use node for transforming Date/Time to String :wink:


1 Like