Hi!
Diary-dates and any date/time-field is stored timezone agnostic. The
timezone on the cliend decides how it is displayed.
If you store the date/time in a character fields on the client (using an
Active Link), it will keep the local time. The time-field should work in
the same way.
If you store the hour-portion in an integer-field, you may be able to
calculate the time difference between the client and the server using
filters. I have not tried it myself thought.
Active-Link:
Set-Fields:
ClientModifyDateTime = $TIMESTAMP$
Set-Fields:
ClientModifyHour = HOUR($ClientModifyDateTime$)
Filter:
Set-Fields:
ServerModifyHour = HOUR($ClientModifyDateTime$)
Set-Fields:
ClientTimezoneOffset = $ServerModifyHour$ - $ClientModifyHour$
Filter: ('ClientTimezoneOffset' <= -12)
Set-Fields:
ClientTimezoneOffset = $ClientTimezoneOffset$ + 24
Best Regards - Misi, RRR AB, http://rrr.se/sv/
> Hi Fred,
>
> Thanks for your reply.
>
> However, my question is more related to the display format of the
> date/time field and whether it is possible to include not only date and
> time information but timezone of the client as well.
>
>
>
> Regards,
>
>
>
> Arkadi
>
> ________________________________
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
> Sent: Thursday, May 01, 2008 11:17 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Timezone info in date/time fields
>
>
>
> No, because the date and time are displayed in the timezone of the
> person viewing the data.
>
>
>
> i.e. A person viewing the diary data in New York would see (assuming a
> 5 hour offset from your GMT examle ;)
>
> 04/10/2008 9:36:20 AR_ESCALATOR
>
> A person in Chicago would see
>
> 04/10/2008 8:36:20 AR_ESCALATOR
>
>
> Fred
>
>
>
> ________________________________
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Parij, Arkadi (Arkadi)
> Sent: Wednesday, April 30, 2008 6:27 PM
> To: arslist@ARSLIST.ORG
> Subject: Timezone info in date/time fields
>
> Hi All,
>
> Is there a way to configure WUT to set the date/time format to include
> the timezone information?
>
>
>
> For example, currently the timestamp and user name in a Diary field are
> displayed as follows:
>
> 04/10/2008 14:36:20 AR_ESCALATOR
>
>
>
> The preferred format would be:
>
> 04/10/2008 14:36:20 GMT AR_ESCALATOR
>
>
>
> Thanks.
>
>
>
> Arkadi
>
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
