How do you pass datetime fields between reports?

[PQTIII]

What is the best way to pass a datetime field from a subreport back to the main report?

Thanks Paul

 

[synapsevampire]

Create a formula which uses a shared variable, as in:

whileprintingrecords;
shared datevar MyDate:= {table.date}

Then you can reference it in the main report AFTER the subreport fires using:

whileprintingrecords;
shared datevar MyDate

-k

 

[synapsevampire]

Missed that you wanted a dateTIME, try:

shared datetimevar Mydate := {table.datetimefield}

or if it's a literal, use:

shared datetimevar Mydate := cdatetime(1970,12,31,10,34,59)

-k