Skip to Content
0
Former Member
Feb 25, 2009 at 09:16 AM

Timezone display in report date

592 Views

Hello

I am needing to add timezone to the DataDate special field. My datetime needs to read for example as,

25/02/2009 10:50:25 AM GMT -2 (in South Africa), or 25/02/2009 10:50:25 AM GMT (in the UK).

I see there is a timezone special field available which uses the system timezone locale but that displays South Africa Standard Time,-120 (for South Africa) and

GMT Standard Time,0,GMT Daylight Time,-60:3.5.0/01:00,10.5.0/02:00 (for the UK), which for me is not suitable.

I have created a formula including DataDateDoes and added tiemzone but given it is a long drawn out string can't get what I need. Does anybody know how I could get the timezone to display as required.

Thanks

Glen