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

Thank you for providing such a powerful product! I am so glad I renewed in at the 3-year level. I am amazed at what a difference the ANKlink makes on cleaning client databases.
C.S., Sequim, WA