Skip to main content

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?

Hi @Billing_Account


I would then use the following formula instead


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

So how this goes

Hi @Billing_Account


I would then use the following formula instead


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

So how this goes


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.”

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.”


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

Reply


Terms & Conditions