Between function in crystal

Posted on 2007-10-10
Last Modified: 2007-10-10
I am suing crystal 9, I want to create a formula that would basically say

if currentdate between 7/1/year(currentdate) and 12/31/year(currentdate) then year(currentdate)+1
else if currentdate between 1/1/year(currentdate) and 6/30/year(currentdate) then year(currentdate)

But I keep getting errors can someone help me with the crystal syntax for this?  
Question by:aebrehm
    LVL 18

    Accepted Solution

    IF currentdate in (date(year(currentdate),7,1) to date(year(currentdate),12,31)) THEN
        YEAR(Currentdate) + 1
    ELSE if currentdate in (date(year(currentdate),1,1) to date(year(currentdate),6,30)) then

    Author Comment

    thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    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…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 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

    9 Experts available now in Live!

    Get 1:1 Help Now