[Last Call] Learn how to a build a cloud-first strategyRegister Now


Best Way to Display Views By Date

Posted on 2005-04-26
Medium Priority
Last Modified: 2013-12-18
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.

Question by:Jaziar
LVL 46

Accepted Solution

Sjef Bosman earned 200 total points
ID: 13866809
Hi Jaziar,

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

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


Author Comment

ID: 13866908
That was it - Thanks for the quick reply

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question