I was asked to add an "as of" date to an Existing Crystal report.

I went into SQL Server (management studio), and figured out how to get a single date meeting the requirement.

Then I copy/pasted the SQL into Crystal's "add command" box. When I put that field in the report footer, it is empty. Go back to SQL server, and it still gives the date I expect.

Checked the formatting properties--it isn't that.

Is there a fix for this?

Normally, I would put the SQL in the server as a stored procedure or function, but it's a vendor-supplied DB that I am not allowed to alter. Can't use profiler for the same reason.

Found a blog article where someone claimed that Crystal demands column names and aliases (but not table names) to be in double quotes. Found that hard to believe but I tried it. No change.

The double quotes are handy if the table, field names are separated by an space (i.e, Adult ID, "Adult ID")

The SQL looks pretty straightforward.  Just as a test, have you tried taking of the where clause to see if you get any data?