I am receiving data from a form (date/time format) and I need to transform that into a date equal to the first day of the date’s month so I can send to another system as the effective date of the transaction. In this systems transactions always have the effdt of the first of the month, regardless of the date of signup.
Input date: 2020-11-06 11:27:13
I want to transform into: 2020-11-01 (the first day of November).
Is this possible to do?