Formula Column: This argument cannot be passed as Date type in formula columns.

(0) Share

Report

Posted on by Zacki90

Hello,

i hope you can help me:

I have two Dataverse tables: VP_BA and VP_Pos

There is a relationship between these two tables (VP_Pos n:1 VP_BA). Both of these Tables habe the column "LT", which is a DateOnly column. I want to create a formula column in VP_Pos. The formula column should take the date from the "LT" column from the table VP_BA if the date from the "LT" column in VP_Pos is empty. So i take the following formula, but there is an error (This argument cannot be passed as Date type in formula columns). Both "LT" columns have the same format. What am I doing wrong?

Screenshot 2024-05-27 144240.png

Categories:

Microsoft Dataverse

All responses (2)

Answers (0)

Zacki90 2 on at

Like (0)

Report

Re: Formula Column: This argument cannot be passed as Date type in formula columns.

It was my mistake, in the advanced options i have to switch the time zone adjustment to "Date only".

Thank you for your support.
v-xiaochen-msft on at

Like (0)

Report

Re: Formula Column: This argument cannot be passed as Date type in formula columns.

Hi @Zacki90 ,

It worked for me.

Best Regards,

Wearsky