Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ignore this one, I have figured it out.
You need to use the ConvertToLocalTime expression.
Ignore this one, I have figured it out.
You need to use the ConvertToLocalTime expression.