Best Way to Display Views By Date

Posted on 2005-04-26
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

    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

    That was it - Thanks for the quick reply

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now