Customer experience | Sales, Customer Insights,...

Error when creating formula column on appointment table

(0) Share

Report

Posted on by PascalKuptz

Hi there,

I get the following error when I try to create a formula column based on the "scheduledstart" column of the "Appointment" table:

Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 207

The formula I am trying to implement is as follows:

DateAdd(Startzeit, 30)

With other columns the formula works fine. It seems to me that it is not possible to reference the column "scheduledstart". Helpfully, I have created a calculated column in which the start time is reflected. If I reference this column for the formula column, the calculation works. I would like to avoid the unnecessary interposed column.

Why can't I access the field "scheduledstart" / start time?

All responses (2)

Answers (0)

PascalKuptz 5 on at

Like (0)

Report

RE: Error when creating formula column on appointment table

Unfortunately not. I also referenced the display name (it turns automatically green when choosing)
Suggested answer

Adam Murabito 30 on at

Like (0)

Report

RE: Error when creating formula column on appointment table

I was able to replicate this in my environment and got an identical error when using the column schema name "scheduledstart". I got this to work with the formula DateAdd('Start Time', 30)

Seems like the formula editor wants the display name instead of the column name.