1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Combining multiple IF and AND statements in Crystal Syntax?

Discussion in 'Software Development' started by Son_Yaqin, Sep 17, 2010.

Thread Status:
Not open for further replies.
  1. Son_Yaqin

    Son_Yaqin Thread Starter

    Joined:
    Jul 20, 2010
    Messages:
    18
    Hi,

    I am trying to create a formula where my report shows either YES or NO next to each record, depending on if a criteria has been met or not.

    Simply put, the FirstVisitDate must be within 14 days of the Tenanted Date - i.e:



    HOWEVER, some staff have not entered a FirstVisitDate therefore null values are not showing any results.

    I need to therefore create a formula that states the above formula

    plus

    if the value is NULL and the CurrentDate is 14 Days (target date) over the TenantedDate then "No"


    The code below works fine seperately but when I combine it does not work.




    Please help?

    Thanks
     
  2. Son_Yaqin

    Son_Yaqin Thread Starter

    Joined:
    Jul 20, 2010
    Messages:
    18
    OK I think I solved it - brackets madness!

     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/950597

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice