how to pass variable in formula field?

[jcao0000]

I have two formula fields which show dates period (start date and end date) of a report. Now I need to calculate another two dates (the start date and end date of last year with the same week number) while querying the database using these two dates. Afterwards I need to pass these two dates to subreport. How can I do this?

I thought of using SQL Expression Field, but can I pass variable to SQL Expression Field?

Also, I probably can create a command object to do a query. But can I also pass variable in Formula Field to command object?

Thanks in advance for the help!

 

[Madawc]

You can reference a formula field from within another formula field, at least in Crystal. You can 'nest' them to suit your needs.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10