Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 05, 2022 09:36 AM
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?
Oct 05, 2022 12:58 PM
I would then use the following formula instead
DateTime_Parse(DATEADD(DueDate, 1, "months"),"MM/DD/YY")
So how this goes
Oct 06, 2022 05:03 AM
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.”
Oct 06, 2022 07:30 AM
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