I'm trying to change Hippy's excellent code to auto- adjust for day light saving, so it works in Australia. Has anyone already done this? My brain is turning to mush just trying. It it complicated by the fact our DLS time starts and ends in two different years and that it must include Feb 29 in leap years.
Hippy's code is written for British time where BST starts last Sunday of March and ends last Sunday of October, both change over at 2am. (BST time). In Australia our Day Light Saving, (DLS time), starts first Sunday of October and ends first Sunday of April the next year.
Hippy's code is in Code Snppets Page 8 thread 18468 from May 28 2011.
Hopefully someone has re-coded this for Australia and can save me form brain damage. If not I'll persevere and post a solution if I'm successful .
Hippy's code is written for British time where BST starts last Sunday of March and ends last Sunday of October, both change over at 2am. (BST time). In Australia our Day Light Saving, (DLS time), starts first Sunday of October and ends first Sunday of April the next year.
Hippy's code is in Code Snppets Page 8 thread 18468 from May 28 2011.
Hopefully someone has re-coded this for Australia and can save me form brain damage. If not I'll persevere and post a solution if I'm successful .