Formula Error

Posted on 2014-08-05
Last Modified: 2014-08-05
Could you please advise what is wrong with this:
 if {@NextDate01} or {@NextDate02} or {@NextDate03} in Date (2014,01,01 ) to  Date (2014,01,31 ) then result = "January 2014"
Question by:GiaHughes
    LVL 69

    Accepted Solution

    I would try:

    if {@NextDate01} in Date (2014,01,01 ) to  Date (2014,01,31 )
    or {@NextDate02} in Date (2014,01,01 ) to  Date (2014,01,31 )
    or {@NextDate03} in Date (2014,01,01 ) to  Date (2014,01,31 ) then result = "January 2014"

    Author Comment

    if i modify the formula to
     if ({@NextDate01}) in Date (2014,01,01 ) to  Date (2014,01,31 ) then "January 2014"

    it works, but I would like the formula to look at several values
      if ({@NextDate01} or {@NextDate02}) in Date (2014,01,01 ) to  Date (2014,01,31 ) then "January 2014"
    but it says it requies a boolean
    Any ideas, can it be done?
    LVL 69

    Expert Comment

    by:Éric Moreau
    have you tried my last comment?

    Author Comment

    Hi Eric

    Yes I did and have awarded you the points

    Author Closing Comment

    Very good

    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

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now