Support 805.461.7300
Sales
Our Technology. Your Success.

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)

« Back to Commands

I just had to tell you how I LOVE the new upgrade.   Man, you talk about making the search and replace task easier!   It's so easy!...Kudos to you guys for making a great product even better.   I'm definitely sold!
P.C., Auburn, AL