Timezone effecting available values on list box

[Anonymous]

Hi,

I am experiencing an issue that I can't understand,

when I look on the BI report (on access point), the selection calendar shows all dates:

but, when another user (from different time zone GMT-5) looks on the same calendar sees:

the 28th is missing :-0

why is this happening? If I change my time zone from GMT+2 to GMT-5 I cant see it as well,

the BI server is GMT-5 as well

help!

[Anil_Babu_Samineni]

Can you let me know the System time zone?

May be use this - ConvertToLocalTime(DateField, 'UTC')

Look more on UTC - Current UTC — Coordinated Universal Time

[Anonymous]

The system time zone is GMT-5

Do you understand where is the problem?

[karthiksrqv]

Hi Nir,

Could it be because 28-Mar-2017 has not yet occured at the place/timezone where your BI-Server is located?

[Anonymous]

it did occur

[karthiksrqv]

Hi Nir,

It could be linked to the time-zone of the 'USER', since the control runs off the browser. It may not be dependent on your BI Server's timezone.

[Peter_Cammaert]

Are these calendar objects linked to fields?

[Anonymous]

yes,

the max value is defined as: = Max( {1}  [Click Date])

[rwunderlich]

Which version and SR of QV?

-Rob

[Anonymous]

12 SR5