gurujee Posted September 20, 2004 Share Posted September 20, 2004 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!! Link to comment Share on other sites More sharing options...
Chuck Posted September 20, 2004 Share Posted September 20, 2004 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7292 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now