Help

Re: Adding a New Row with {Date}

704 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Billing_Account
4 - Data Explorer
4 - Data Explorer

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?

3 Replies 3

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