Date Calculator

[gurujee]

I need to add an If statement within the following calculation that includes a date field in mm/dd/yyyy format to fall into the range for the final calculation:

Currently, the field reads:

If(Agency="ABC" and Gender = "Male", 1,0) or If (Agency="CDE" and Gender = "Male", 1,0)

I need to add:

If(Intake Date=07/01/2004...09/30/2004) in whatever format will work within this calculated field. I cannot process the report with the date criteria as a find script because the report must give date on a Quarter date range and a YTD date range.

Or, should I just create a date calculator that assigns a number to each day of the year. And, if this is how I should proceed, what is the easiest way to create the calculator?

Thanks!!

[Chuck]

First of all, just to let you know, you can simplify your initial calculation so that it reads as follows:

( Agency = "ABC" or Agency = "CDE" ) and Gender = "Male"

This should have the same result as what you gave.



Second, I don't know where in your calc you want to add the date criteria, but if I understand what you want to do, this should return the correct results:

Intake Date > Date( 7, 1, 2004 ) and Intake Date < Date( 9, 30, 2004 )

Chuck