CompleteDate = convert(char(8), getdate(), 3) +' '+
convert(char(8), getdate(), 8)
or
CompleteDate = convert(char(8), getdate(), 3) +' '+
convert(char(12), getdate(), 14)
The first line shows the date. The second line shows the time.
If you're pulling a specific date field instead of the current date/time,
replace "getdate()" with "CallDate" or whatever the field is named.
JOsh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart