Best Way to Display Views By Date

I have a date field [InputMonth] in my form.  It is set to custom to show only Months with a default value of @Today.
Right now it shows the names of the month (mmmm).  

In my view I have a select statment in a view called April I am wanting all documents created in April to show up in the view.

SELECT Form = "Request" | Form = "Response Form" & AttachFlag = "Yes"  & Subject = "Ledger Spreadsheet" & InputMonth = 04

This is not working.

JaziarAsked:
Who is Participating?
 
Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
Hi Jaziar,

Don't forget operator precedence, i.e. the & has higher precedence than the |
And the test for the month sghould be different.

Try:
    SELECT (Form = "Request" | Form = "Response Form") & AttachFlag = "Yes"  & Subject = "Ledger Spreadsheet" & @Month(InputMonth) = 4


0
 
JaziarAuthor Commented:
That was it - Thanks for the quick reply
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.