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 149
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