Hi Ashfaq,
Almost there, I used "max(date([Received Date],'DD.MM.YYYY')) as [NReceived Date]" and this produces a date when I run the script. This NReceived Date column is actually a time stamp which will have date and time.
I am getting duplicate records in other words for some clients I am getting back more than one transaction. If I export to excel and click on the date, I can actually see the time stamp in the cell, although the cell will be formatted to date only.
I really wanted to end up with just one transaction per client being the latest transaction date hence the "max". How do I get rid of these duplicates?
Thanks
