AnsweredAssumed Answered

Date is in range Calculation

Question asked by biggorilla on Sep 3, 2014
Latest reply on Sep 6, 2014 by biggorilla

Question - I'm trying to write a calculation that would determine if a date is within a certain range - (ie Sep 1, Current Year - Dec 31, Current Year).  I've tried with a Case Statement and also with an If Statement.  The calculation field is looking at a related table of parent records.

 

If (Date ( 9 ; 1 ; Year ( Get ( CurrentDate ) )  ≤ families_LOGHOURS::BacktoSchoolNight_Attendance ≤ Date ( 12 ; 31 ; Year ( Get ( CurrentDate )) ; "Yes"; "No")))

 

I keep getting the "too many parameters" error dialogue

 

Thanks for the help!

 

Alberto

Outcomes