Support 805.461.7300
Sales
NEW SITE. 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

We 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.
K.W., Hobe Sound, FL