Jump to content

Date Calculator


This topic is 7216 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 7216 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.