Adding a New Row with {Date}

[Billing_Account]

I am attempting to create an automation that creates a New Row in in Table {Bills}.
I the trigger ({Status}=“Recurring” + {Paid}=“True”) works just fine.
I have a {DueDate} Column and Formula Column {NextMonth} that successfully generates a date one month ahead (DATEADD(Due, 1, ‘months’). Works just fine.
However: I cannot run the Automation successfully. I want the {Date} Field in the New Record to contain the Value from {NextMonth} from the Initial Record. When I select this Dynamic option, I end up getting some variation of the following Error no matter what I try:

“Field “Due” cannot accept the provided value: Could not convert string to date.”

Why is this?

[Mohamed_Swella1]

Hi @Billing_Account

I would then use the following formula instead

DateTime_Parse(DATEADD(DueDate, 1, "months"),"MM/DD/YY")

So how this goes

[Billing_Account]

I end up with #ERROR in the Field on the Bills Table, and the automation returns:
“Field “Due” cannot accept the provided value: Could not convert string to date.”

[Mohamed_Swella1]

I tried it now and got the same error in the formula, its because it is already a date

But I also tried it in the automation and it was ok, maybe screenshot the automation part with this dynamic field