need to output datetime value from one table

[madaos]

need help how create a crystal report formula for the following

I need to output datetime value from one table, but need to meet a condition value from another field in the same table.


per example

table structure is the following

customer_fname, customer_lname, prod_id, datetime
lastname, firstname, 9300, time

I need the datetime output only when the prod_id is 9300 for this customer.
any help greatly appreciate

 

[CoSpringsGuy]

if you only want the records from the database that meet your criteria use this formula and place it in the record selection expert
//
{prod_id} = "9300"

if you want all the records but only want to show the date time for those that meet your criteria, create this formula and place it in the detail section.

//
if {prod_id} = "9300" then {datetime}


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection