2 Replies Latest reply on Nov 4, 2012 8:00 AM by philmodjunk

    Case Statement

    AngeloTee

      Title

      Case Statement

      Post

             
      •           Can someone help me include a Case Statement to evaluate a answer like, if DateA is blank, then use today’s date, (updating automatically to current date the next day and the following day and so on)

      Case_Statement.gif

        • 1. Re: Case Statement
          schamblee

               You don't need a case statement, for this an if statement is easier.

               If(IsEmpty(DateA)=1;Get(CurrentDate))

               If you just want to display the current date on your layout then you would just need a calculation

               Get(CurrentDate)   

               (Make sure the reture type is date)

               then click Storage Options and then click "Do not store calcualation results, recalculate as needed".

                

          • 2. Re: Case Statement
            philmodjunk

                 This can be simplified even more:

                 If(IsEmpty(DateA);Get(CurrentDate) ; DateA - 134 )