I'm just trying to subtract one column from another in formula (these are small integers). If I use the following, I get "Formula: Invalid type in subtraction operator". I'm setting the new column Data Type to "Int32".
[Openings] - [Openings Filled] and my new column name is "# Openings Remaining".
Solved! Go to Solution.
if you put a select in front of your formula tool, are these two fields truly NUMERIC?
That was the issue, they were coming in as V_WString. When I used SELECT to change them to Int32, the subtraction worked. Thanks!
Guys, i'm with a similar issue.
Is it possible to subtract two different columns containing dates?
The formula that I included to appear in a new columns was:
[RepairVisitDate]-[Terminated Date]
Does the expression look ok to you?
Thanks
Celso
Try DateTimeDiff([RepairVisitDate],[Terminated Date],'days')
It worked. Thank you!
Celso