0

I explored all the functions available in the transformer, but I couldn't find the exact function to get the last day of the previous month in standard format, i.e. dd/mm/yyyy. Please help me in this regard.

The field that needs to appear is in the COL_C field. enter image description here

inside it I can't put anything that returns me this result

Enzo Niro
  • 1
  • 1

1 Answers1

0

You can use DateOffsetByComponents to substract the current day. Cut out the day part from your date and substract it with above function.

i.e. 16/12/2022 - 16 = 30/11/2022

MichaelTiefenbacher
  • 3,805
  • 2
  • 11
  • 17