Jason
Mon Dec 20 21:12:37 CST 2004
This is the result of a mistake made by the developer. My Bad! ;-) While
writing the e-mail template editor I neglected to allow you to choose
whether or not you wanted date, time or date and time.
There is a manual fix for this, although it is a little tricky. Each email
template actually get's stored as XML. The xml document is then run through
an XSL template that generates a new XSL template that then will output the
final HTML for the email when you transform the XML returned from the
platform with it.
If you only want to show the date or time, you'll need to manually extract
the XSL from the Body column in the TemplateBase table for the template you
need to fix. Just go find the dataslug you want to only show the date for.
It'll be in an xsl:choose. Modify it so that only the date get's written
out instead of the whole string. You can just grab everything to the left
of the first space.
Once you do this, you'll need to put the XSL back in the database. I would
personally just write a quick console app to both write it out and insert it
but you could also go directly to the DB as well. Obviously, once you make
this change if you use the editor to change the template, you will need to
reapply your changes manually.
There is one more method to fix this automatically for all date fields if
you NEVER want the time shown, but it's a little more complex. If what I
talk about above makes sense, email me for further details.
Jason Hunt
Invoke Systems
http://www.invokesystems.com
"Fred" <Fred@discussions.microsoft.com> wrote in message
news:D65ABC63-F698-4627-BDED-D279C94C55B9@microsoft.com...
> I'm making an e-mail template for a quote. In the template I use data
> fields
> also the date of the quote.
> In the e-mail it will show the date and the time but I don't want the
> time.
> Is there anyone who can help me in solving this?
>
> Thx in advance