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())))

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())

Replace all date with DTOC(date())

This will give you 12/25/2030

First the kudos. Accuzip, already the best, is even better with the new CASS speed. I don't know how you did it but it is fast, fast, fast!

C.P., Houston, TX