Changing the formula within the report

[junction123]

I need to change the datasource in the formula for the report header.

I need to replace currentdate in the the formula shown below, with a date field from a table, tms_dates.datetime, where tms_dates is the table name and datetime is the column.

"Dated: " + totext(currentdate,"MMM dd yyyy&quot

Any suggestion is appreciated

Thanks!
junction123

 

[Reebo99]

"Dated: " + totext(tms_dates.datetime,"MMM dd yyyy&quot

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[junction123]

Thanks Reebo.

Apparently this did not give me the correct data.

I need the header date to be based on a column value from the table.

The header should be:

Position And Security Data Date: February 10 2004 12:00AM
Pending Trade Data Date:February 10 2004 12:00 AM

My formula is:

@datetime
If {tms_dates.event}="trade_date" then
"Pending Trade Data Date: " + totext({tms_dates.date_time},"MMM dd yyyy&quot



@datetime1
If tms_dates.event = "trade_date" then
"Position and Security Data Date: " + totext({tms_dates.date_time},"MMM dd yyyy&quot

Any suggestions?

Thanks in advance
junction123

 

[synapsevampire]

The formulas seem fine.

How this table is joined to existing tables is unclear, and what does "Apparently this did not give me the correct data." mean?

Did it return a date?

-k

 

[junction123]

Actually using subreports worked fine and I was able to return the data based on the Header Date.


Thanks
junction123