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) |
V.J., Los Angeles, CAThe [Merge Fields feature]...saved me hours of having to do a bunch of manual address corrections in an updated database, that I already had done months ago on my original database. What a relief. Certainly Rolaids can't top this.