Add a MAX Date in a BOA Report
I need help adding a MAX Date to a report.
I Currently have the query returning all names and dates for a specific Code. most names will have the specific code multiple times with different dates.
I just need the most recent date for all names.
I Currently have the query returning all names and dates for a specific Code. most names will have the specific code multiple times with different dates.
I just need the most recent date for all names.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>"I Currently have the query"
How did you get the current query to work? What I have suggested above alters the query.
If you would like to share the existing query we can most likely make the changes you need.
Otherwise please "sample data" and "expected result" and we can demonstrate you to reach the wanted result by SQL. (Excel can be useful for this.)
If your "query" isn't SQL, what is it?
How did you get the current query to work? What I have suggested above alters the query.
If you would like to share the existing query we can most likely make the changes you need.
Otherwise please "sample data" and "expected result" and we can demonstrate you to reach the wanted result by SQL. (Excel can be useful for this.)
If your "query" isn't SQL, what is it?
>> No the "date" field is not date.<<
What is the datatype and in what format? As PortletPaul has suggested, some sample data with expected results would be most helpful. It would also help if you could describe your table showing column names and datatypes.
What is the datatype and in what format? As PortletPaul has suggested, some sample data with expected results would be most helpful. It would also help if you could describe your table showing column names and datatypes.
ASKER
sorry, i got busy last week and then we had the holiday.
Dont mean to be cryptic with the post but very sensitive info.
I will see what I can do about providing more info.
Thanks.
Dont mean to be cryptic with the post but very sensitive info.
I will see what I can do about providing more info.
Thanks.
ASKER