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) |
K.W., Hobe Sound, FLWe love the database and how simple it is for us to make simple codes as our business always has since 1955...We are grateful to you and your staff that take client service so seriously.