itsjustkatie Posted February 16, 2008 Posted February 16, 2008 Hi, I am trying to create a summary of items that are marked "OK for Press" during a certain time frame range. Ideally, I'd like to be able to view a summary page that would tell me how many items were approved for each week. I tried this calculation that is then counted in a summary field, but it's not working: If (approved = "OK for Press";1;0) & (approval_date = Date ( 2 ; 11 ; 2008 ) & "..." & Date ( 2 ; 17 ; 2008 ) ) Thanks in advance for all of your help! I appreciate it! These boards are great.
mr_vodka Posted February 17, 2008 Posted February 17, 2008 Try this. approved = "OK for Press" and approval_date >= Date ( 2 ; 11 ; 2008 ) and approval_date <= Date ( 2 ; 17 ; 2008 )
comment Posted February 17, 2008 Posted February 17, 2008 It's not good practice to hard-code dates (or any data) into calculations. What will you do next week? Why don't you either find the records that meet the criteria, or define a relationship that filters the related items by the same criteria (use a calculation field = "OK for Press", and two more calculation fields to get the current week's firat and last day).
itsjustkatie Posted February 18, 2008 Author Posted February 18, 2008 thanks very much mr vodka and comment! I will give your solutions a try. there were only a couple weeks that I needed to pull, so I was going to hard code them - but I know that's a big no-no! Comment, you are right, what if things come up later than the weeks I needed? thank you again, will report back!
itsjustkatie Posted February 23, 2008 Author Posted February 23, 2008 Update! I had to use the hard coding option since I needed to get the info available to everyone asap. It works well! I am however working on a non-hard coded solution in my spare time. Thanks again for the help.
Recommended Posts
This topic is 6179 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