Hi,
I am trying to create a formula in an existing query. If the date value referenced (lets say 07/13/2018) is less than or equal to today's Date() the system needs to perform the calculation of a specific multiplier being applied to a field in the table.
So for example, here is the basis of what I am trying to accomplish minus the important syntax:
=iff(Today’s Date <= '07/13/2018’, [PP Deduction] * 13
else
=iff(Today’s Date <= ‘07/27/2018’,[PP Deduction] * 12
And then continue this on for 12 other date values that have a different multiplier value.
Is this possible?
Thanks