The Totext function can be used to convert a date to a string. Look at the help file for Totext to see how it works. You can make another formula field called displaydate (or whatever) and use
Totext ({event.date},"MMM d, yyyy")
Then make your string say
'Your next appointment is on ' &
{@displaydate} & '. Please call us ............ etc etc
If you are not sure if the date field is really a date, you might want to first use the ISDATE function. That returns a boolean to tell you if the date field is a valid date.
I don't know about forcing a carriage return.
Good luck.
Edited by JohnT - 01 Oct 2008 at 7:47am
IP Logged
