TM1 Forum

Just encountered an issue with TI Now() function under 9.5.2 FP1 as I'm getting different results on two servers (2008R2) that have both System time set to GMT+8.
One server return GMT time, whereas another server return local time (which is GMT+8).

Based on my experience and document, Now() should return the local time which in my case GMT+8, hence something is very wrong with the first server.

I don't think this is a TM1 bug but rather some configuration on the sever OS, else I'll raise a ticket to IBM. Any suggestion ?

Quite frankly I don't know for sure if this will affect what NOW() returns, but it is possible to configure transaction logging to use either local time or GMT. To do that edit the tm1s-log.properties file.

You can either use or Check if this parameter is the same or different for your servers.

Thanks. I doubt this will change anything as both server has the exact same log setting.

NOW() in TM1 should be utilizing standard windows API to obtain the system time, I think I'll write a WSH script that call NOW() and see if I get the same results.

kangkc wrote:I think I'll write a WSH script that call NOW() and see if I get the same results.

You can just do this on the command line: