APEX

Hello

Wonder if anyone knows how to set a Dynamic action which affect the same column in an IG

I'm trying to force that if a date is input on a column, whatever the date is, the column change it to the first day on that month

Checked these articles, but the affected column is/are not the same as the data is being input.

https://diveintoapex.com/2022/02/09/trick-to-reference-field-value-in-dynamic-action-on-grid-column/

https://forums.oracle.com/ords/apexds/post/interactive-grid-dynamic-action-set-multiple-column-values-6455

I tried to do this creating a Change DA with a PL/SQL action which set the column with the following expression, enabling the Suppress Change Event to prevent cyclic execution, but the column ends empty

:START_DATE := to_char(trunc(to_date(:START_DATE,'DD-MM-YYYY'),'MM'),'DD-MM-YYYY');

Thanks in advance