We have the following functions available to convert data into a specific type:
We also have things like:
I have a need to force something back into a price so I can use it in math.
Thanks for considering!
Solved! Go to Solution.
Price is just Decimal with some implied formatting, it seems to me. What would PRICE() give you that DECIMAL() doesn’t?
I just noticed yesterday that we’re also missing .
DURATION()
Price is just Decimal with some implied formatting, it seems to me. What would PRICE() give you that DECIMAL() doesn’t?
I guess I haven’t tried
[Price] + [Decimal]
I assumed it wouldn’t work being two different types.
Update: they do work together.
You just don’t know what you don’t know
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |