Format Date in a merged field
I am tring to email lots of principals. I have a script that merges the Principal's name and an appoinment date. however the date is always formatted as 9/10/11. I need it to look like the way my appointment dated field is formatted (Sep, 10,2011)
This is what I have
"Hi "& School_Info::Principal_name &"¶It is that time of the year again and I have tentatively booked "& School_Info::Shoot_date &" for your photo day.¶Please check your schedule and let me know if this is to your satisfaction. In case I don't hear from you soon, I will follow up this email with a phone call just to confirm that you have received this email.¶Our photographer(s) will be there early enough to start at 8:30 would you please let me know if you would like them to start earlier?¶¶Thank you¶
What else do I need to add to this "Send mail script"
Thanks in advance