AnsweredAssumed Answered

Format Date in a merged field

Question asked by Mehrdad on Jun 15, 2011
Latest reply on Jun 15, 2011 by Mehrdad


Format Date in a merged field


Hi Everyone

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