HI everyone

 

Im trying to do a field calculation which involves a date range - however I cant work out how to right an operator for a date range between 2 dates.

 

I have something like this:

 

If(course start date > Date ( 1 ; 1 ; 2013 ) <= Date(12 ; 31 ; 2103 ) ; adminfee received; 0)

 

What am I doing wrong please...

Basically if the course start date is between 01.01.2013 and 31.12.2103 then i want the admin fee to appear - if not to put a 0

 

thanks for your help

alison

Case(

course start date > Date ( 1 ; 1 ; 2013 ) and course start date <= Date(12 ; 31 ; 2103 ) ; adminfee received ;

0

)

fantastic thank you - you learn something new everyday!

What will you do next year?

Basically if the course start date is between 01.01.2013 and 31.12.2103

If 'between' those dates should not 1.1.2013 be included? Then calc should not be course start date > Date ( 1 ; 1 ; 2013 ) but rather >= (*greater than or equal to). And as pointed out, hard-coding the date isn't good idea because a developer will need to open the calc and change it every year (if it isn't forgotten).

Would it be safe to say that, if the CourseDate is dated one year following the current year then it should have AdminFee applied?

* I cannot make the FM symbol of >= (on ipad) which is equal sign with slash through it.