Skip to Content
Former Member
Sep 12, 2014 at 12:41 PM

Work Status Report Date and Time Setting


Hi all

We are running BPC10 on servers configured with Central European Time which is currently 2 hours ahead of GMT allowing for Daylight Savings Time.

From what i can see in BPC10 date and times are now stored in GMT (Zulu time) in the Audit activity tables so when a user updates the work status at say 11:00AM local CET time then a value of 09:00AM GMT is stored in the Audit Activity Header table.

We have a report in excel that uses the EVLCK formula and will return the correct value of 11:00 am however if we run the Work Status Audit report on the Planning and Consolidation home page with user preferences set to Central European Time +1 then the time is displayed as 10:00am suggesting that daylight savings time is not accounted for. We need to set the time to Eastern European time +2 hours to display the correct figure.

Can anyone explain why this happens? Has DST been overlooked?