Skip to main content

Adding a New Row with {Date}

B

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

M

Hi @Billing_Account

I would then use the following formula instead

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

So how this goes

B
Mohamed_Swella1 wrote:

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

M
Billing_Account wrote:

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


Most helpful members this week

Terms & Conditions