Finding a date with a Calculation

[sboisvert]

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

[efen]

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; "" )

[sboisvert]

Will this also support multiple records with the same date?

Thank you so much for the quick reply back efen!

[sboisvert]

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!

[efen]

See if the attached makes it clearer

printdue.zip

[sboisvert]

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!

[sboisvert]

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?