Support 805.461.7300
Sales
Our Technology. Your Success.

Add a date to a field

Two ways to add a date to a character field:

Replace all date with CMONTH(DATE())+" "+ALLT(STR(DAY(DATE())))+", "+ALLT(STR(YEAR(DATE())))

This will give you December 25, 2030

Replace all date with DTOC(date())

This will give you 12/25/2030

« 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