Forum Discussion
Jamie Burke
Sep 27, 2017Copper Contributor
How to add an "IF" date rule to a current formula?
I have a formula that is already written with a couple of "IF" rules and I am wanting to add to it. The current formula is =IIf([HW only]=No,[rent]*0.07613,IIf([state]="mo",[rent]*0.07613,0)) This...
Jamie Burke
Sep 28, 2017Copper Contributor
It's a VBA function.
SergeiBaklan
Sep 28, 2017Diamond Contributor
In VBA date constant looks like
#10/1/2017#