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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Building a string from previous dates

Status
Not open for further replies.

ashab02

Programmer
Jun 28, 2005
87
GB
Hello
I have a set of data and one case reference may have 10 dates.
What i want to do is take the record with the latest date but then also want a column which will list my previous dates with a ',' seperating them. So something like:

12/01/2006, 15/01/2006, 12/05/2007.

Can anyone help?

Shab
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top