Using the RecordSelectionFormula in Crystal Reports
I'm trying to use the RecordSelectionFormula on a datetime field.
something like:
string time = DateTime.Now.ToString();
reportDocument1.RecordSelectionFormula = @"{Alarms.Moment} < " + time ;
returns:
"The remaining text does not appear to be a part of the formula"
and:
string quotes = @"""";
string time = DateTime.Now.ToString();
reportDocument1.RecordSelectionFormula = @"{Alarms.Moment} < " + quotes + time + quotes;
returns:
"A date-time is required here"
and:
reportDocument1.RecordSelectionFormula = "{Alarms.Moment} < " + DateTime.Now;
also returns:
"The remaining text does not appear to be a part of the formula"
What I'm I doing wrong?