Date/Time Output Discrepancy

I've used two ways to get the {!Case.Created On} field but the outcomes were
different.

In 'E-mail To' action of Workflow Rule: the outcome was '07/21/2006 10:50 AM
(GMT+08:00) Beijing, Chongqing, Hong Kong SAR, Urumqi'

In the Email Template: the outcome was '07/21/2006 10:50 AM'

How can I get a consistent format, and can it be presented in the other
formats, e.g. UTC?

Shashi
Mon Aug 21 23:06:02 CDT 2006

Workflow by default will give you a fully formated date time string. To get
the required result. you will have to create a small .net assembly that takes
in the datatime parameter and returns the fomated string. you can have the
timzone and format string passed into the assembly so that it gives you full
control when constructing the wf rules.

gordon
Wed Aug 23 20:51:01 CDT 2006

Hi Shashi,

Thanks. As I don't know how to pass the returned string back to the
workflow action, would you please help me?

Gordon



"Shashi" wrote:

> Workflow by default will give you a fully formated date time string. To get
> the required result. you will have to create a small .net assembly that takes
> in the datatime parameter and returns the fomated string. you can have the
> timzone and format string passed into the assembly so that it gives you full
> control when constructing the wf rules.