Yes there are solutions, but you are too vague in your requirements. Is an example that I use in one of my e-mail templates:
You have been scheduled for a session with: <<Cal->UserID>>
If necessary he will be calling you using: <<&Phone1>>
Meeting Date:
<<wdate(Cal->OnDate, 3)>>
Meeting Time:
Eastern:
<<iif(left(Cal->OnTime, 2)>"12", alltrim(str(val(left(Cal->OnTime, 2))-12))+right(alltrim(Cal->OnTime), 3)+"pm", alltrim(Cal->OnTime)+"am")>>
Central:
<<iif(left(Cal->OnTime, 2)>"13", alltrim(str(val(left(Cal->OnTime, 2))-13))+right(alltrim(Cal->OnTime), 3)+"pm", IIF(padl(alltrim(str(val(left(Cal->OnTime, 2))-1)), 2, [0])=[12], padl(alltrim(str(val(left(Cal->OnTime, 2))-1)), 2, [0])+right(alltrim(Cal->OnTime), 3)+"pm", padl(alltrim(str(val(left(Cal->OnTime, 2))-1)), 2, [0])+right(alltrim(Cal->OnTime), 3)+"am"))>>
Mountain:
<<iif(left(Cal->OnTime, 2)>"14", alltrim(str(val(left(Cal->OnTime, 2))-14))+right(alltrim(Cal->OnTime), 3)+"pm", IIF(padl(alltrim(str(val(left(Cal->OnTime, 2))-2)), 2, [0])=[12], padl(alltrim(str(val(left(Cal->OnTime, 2))-2)), 2, [0])+right(alltrim(Cal->OnTime), 3)+"pm", padl(alltrim(str(val(left(Cal->OnTime, 2))-2)), 2, [0])+right(alltrim(Cal->OnTime), 3)+"am"))>>
Pacific:
<<iif(left(Cal->OnTime, 2)>"15", alltrim(str(val(left(Cal->OnTime, 2))-15))+right(alltrim(Cal->OnTime), 3)+"pm", IIF(padl(alltrim(str(val(left(Cal->OnTime, 2))-3)), 2, [0])=[12], padl(alltrim(str(val(left(Cal->OnTime, 2))-3)), 2, [0])+right(alltrim(Cal->OnTime), 3)+"pm", padl(alltrim(str(val(left(Cal->OnTime, 2))-3)), 2, [0])+right(alltrim(Cal->OnTime), 3)+"am"))>>
Not to Exceed:
<<ltrim(str(int(Cal->Duration/60)))+[ hr ]+ltrim(str((Cal->Duration/60-int(Cal->Duration/60))*60))+[ min]>>
Reference: <<Cal->Ref>>
<<Cal->Notes>><<Cursor>>
DJ Hunt
Phone:
(978)2-3333
WebSite:
- The Hacker's Guide to GoldMine Premium
- One-on-One GoldMine Technical Support ( Fee Based )