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
J.S., Newark, OHI wanted to drop you a line to tell you that working with Accuzip has been a breath of fresh air. I’ve been able to speak with a Live person each and every time I call. Your unlimited Tech Support, Personal Training and Price Lock Guarantee has given me the confidence that I made the right choice. Accuzip was able to solve my list issues and add value to my existing database at a more than reasonable price.
