Insert slashes into a field that contains a date
| Replace all date with LEFT(ALLT(date),2)+"/"+SUBSTR(ALLT(date),3,2)+"/"+SUBSTR(ALLT(date),5) |
| Replace all date with LEFT(ALLT(date),2)+"/"+SUBSTR(ALLT(date),3,2)+"/"+SUBSTR(ALLT(date),5) |
C.P., Houston, TXFirst the kudos. Accuzip, already the best, is even better with the new CASS speed. I don't know how you did it but it is fast, fast, fast!