Hi!

I am trying to create a field that will display text from a record based on finding a specific date in the record. I have this calculation written but I know it's not correct:

If ( print::final_lasers_due = Date ( 2 ; 12 ;2010 );print::Project Name )

Basically I want it to search the records in "Print" to find a record where the final lasers due (this is a date) equals a specific date I enter. In this case 02/12/2010, and then show what the project name is in the field.

In addition, and I'm not sure this is possible, I would like the field to display the project name for ALL records in print that have that date.

Any help would be amazing!! Thank you all!!

The field won't "find" any records with the chosen date but it will flag them.

Create [or use] a global date field in which the user can enter the chosen date and amend your calc to

If ( print::final_lasers_due = globalDateField);print::Project Name; "" )

Will this also support multiple records with the same date?

Thank you so much for the quick reply back efen!

Ok, looks like I'm doing something wrong. I created a new field like you said and then entered the value (date) in that field but there is nothing coming up in the field with the calculation.

I took a date that I knew existed in the final lasers due field.

Thanks!

See if the attached makes it clearer

printdue.zip

I think I got it! That file was a huge help thank you so much. Seeing these types of things are a huge help!

Thank you again for taking the time and helping me along the path!

Ok, not sure if this is correct, I know it's not working right now, but is it possible to have a List function work in conjunction with an IF function?

List ( If ( final_lasers_due = calendar::datefield_2;Project Name;"" ) )

The IF function works great (I have the results showing in a portal but they are not showing at the top even when sorting them, they are showing halfway down and I need to scroll to see them.). Is there an easier way?