I've had a lot of time this weekend to putter on my to do list ... hence the pestery questions. If anyone can help me, I'm very appreciative.
OK, in this bit of code, I want to retrieve the most recent date out of a string of dates (accounts entered into my database).
I ran some scratch programming to run in a mass update window, and it's not bad.
vListingArray = (@xlookupall(@FN,CltNo, "DR Screen!DBCltNo", ("DBlisted")))
// vListingArray = @Replace(vListingArray, "/", "")
vListMax = @max(vListingArray)
With this, I get a good string of dates:
2010/12/02;2010/12/02;2010/12/02;2010/12/23;2011/01/14;2011/01/14;2011/01/14;201
1/01/14;2011/01/14
But my @max command only gives me
2010
How can I get it to give me "2011/01/14"?
Thanks again!