Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date formula
- Thread starter Hellopin
- Start date
Please explain what you mean by "get the data between date range".
Much more info is needed to adequately answer your question.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Much more info is needed to adequately answer your question.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #3
I think things are still a little unclear but I think this is what you have:
You want data to be returned from your database where a database date field is in a range that is defined by 2 parameters.
Try this:
Go to Report, Selection Formulas, Record.
Enter this into the editor window, but modify it with your fields:
{table.date_field} in {@Date_Parameter1} to {@Date_Parameter2}
If this is not what you are looking for, I think you will need to get more detailed in your response.
~Brian
You want data to be returned from your database where a database date field is in a range that is defined by 2 parameters.
Try this:
Go to Report, Selection Formulas, Record.
Enter this into the editor window, but modify it with your fields:
{table.date_field} in {@Date_Parameter1} to {@Date_Parameter2}
If this is not what you are looking for, I think you will need to get more detailed in your response.
~Brian
- Status
Similar threads
- Locked
- Question