Invalid operator all of a sudden

Hello there,

Today after making a copy of one of my prototype apps, I came across a bunch of errors. I was able to fix and understand dozens of them but there is one I am unable to understand and or fix (attached).

I did read the โ€œDate and Timeโ€ and the โ€œMath Expressionsโ€ articles again but Im still lost.

Can anyone see why an operator on this formula would have become invalid all of a sudden? Is (-) the only operator on this expression?

Thank you very much!

0 7 150
7 REPLIES 7

Which column type is [Final Payment Due]?

Hey @SkrOYC : We posted almost at the same time but you were first. Nice that our queries are the same

Nice to see Iโ€™m noticing the same things as the big boys do. Feels like Iโ€™m on the right path

Your community contributions are very impressive. We all keep getting insights from each other in the community.

Could you please check the column type of [Final Payment Due]

@SkrOYC @Suvrutt_Gurjar
Thank you very much! You were right, the type had changed from Date to Price by itself. It is now working, I really appreciate it! So, the operator (-) became invalid because you canโ€™t calculate time using a price

3X_f_6_f62a0af52b9eed62bc52b353794cdb1790c3af65.gif

Top Labels in this Space