Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

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.

Posted

Try this.

approved = "OK for Press" and approval_date >= Date ( 2 ; 11 ; 2008 ) and approval_date <= Date ( 2 ; 17 ; 2008 )

Posted

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).

Posted

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!

Posted

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.

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 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.