I have a query that I need to get the date criteria from a form, but the fields are a little different because they have a formula in them. I have screenshots if needed. The formula in my Fiscal Year field is: FYear: IIf(Month([RideDATE<7,Year([RideDATE]),Year([RideDATE])+1) My Month field is:FMonth: Month([RideDATE])
Adam Schwanz
@Reply 2 years ago
And what is happening? Do you get an error, wrong numbers, or something else?
If you copy/pasted it, you have a syntax error here with no closing bracket [RideDATE<7 you also have no closing parenthesis on the year for Month([RideDATE
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
