I need to display report generated date in BIP report and this should be client(browser) current date/time. I tried the following things.
1. have used MS Word Native Date/time using Insert->Date/Time. And we have chosen the M/d/yyyy h:mm:ss am/pm format. but it is printing BIp server date/time, not client date/time.
2. <?xdofx:sysdate?>, <?xdoxslt:sysdate_as_xsdformat()?> and <?format-date:xdoxslt:sysdate_as_xsdformat();'SHORT_TIME'?> are giving GMT Date/Time, but we need client Date/Time.
3.<?xdoxslt:sysdate('DD-MON-YYYY HH12:mi:ss')?> is giving the system date/time of the machine where BIP server is installed.
Could you provide some help in this??
Thanks for the reply vetsrini.
If we use format date with timezone, we need to hard code the timezone right? The default timezone: $_XDOTIMEZONE is set to GMT, so we can't even use the variable $_XDOTIMEZONE. Can't we get the client timezone during run time.
what would return something like this:
for my opinion,
in the countries where time is switching (winter/summer) using the hard coded time zones in the format-date() cause a problem:
if we enter the date in date prompt in summer it will return PM_DT = 2010-07-20T00:00:00.000+04:00
in winter 2010-07-20T00:00:00.000+03:00, so,
using <?format-date:PM_DT;'DD.MM.YYYY';'GMT+3'?> return 2010-07-20 in winter and 2010-07-19 in summer.
I'm wondering if you ever solved your problem?
I have a similar issue where the default timezone is GMT (as is _XDOTIMEZONE) and I want to format datetime data in the user's local timezone so that it handles daylight savings, and it doesn't use GMT or server timezone. I'd hoped to be able to get the timezone from the browser or header somewhere
Thanks for any help you can provide