6 Replies Latest reply on Jun 15, 2011 1:02 PM by Mehrdad

    Format Date in a merged field

    Mehrdad

      Title

      Format Date in a merged field

      Post

      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