Carrot reference
Operators
- (subtract)
an operator used to subtract an expression from another expression syntax valueone valuetwo sample usage (1 2) 3 returns 4 ('2021 01 02') 1 returns 2021 01 01 supported data types if a number , money value, or percent is subtracted from an expression of the same type, the difference between the two values will be returned if the left side is a date , and the right side is a number , it will return the date minus that many days date is subtracted from another date the number of days between them will be returned if a number value is subtracted from a money value, the money value will decrease by the value of the number if a percent value is subtracted from a number value, the number value will decrease by the value of the percent ; the reverse operation will also work, however the returned value will still be of type number see also number docid\ uci5tctfvbhonej6zqijg money docid ks5d2xbfor9d8wfrivny percent docid\ fbn7bfahlfpv4f1c53dxa string docid\ ujw2aqaktel5uuklup73s date docid\ xtaqdzvlbtakjxrnpfwe9 + (add) docid\ dslknikexseseztv3c5zv