Time field incorrect from Database during British Summer Time

[#1]

Hi,

I have just noticed that my database does not increment the time forward one hour to compensate for British Summer Time (The clocks going forward one hour).

On one of the fields called logdate my values shows as:

23/03/2012 13:17:00

26/03/2012 13:17:00

However as the clocks went forward an hour on the 24/03/2012, the true value of the field should be:

23/03/2012 13:17:00

26/03/2012 14:17:00

Is there anyway that this can be changed in Qlikview, also if it can be changed in clickview, is there a way it can calcuate based on system time, therefore I wont have to write expressioned that include the clocks going forward and back for the next day 50n years .

Regards,

Jon

[#2 · Accepted solution]

Ignore this one, I have figured it out.

You need to use the ConvertToLocalTime expression.