peskywinnets
Registered User.
- Local time
- Today, 04:45
- Joined
- Feb 4, 2014
- Messages
- 578
I'm requesting stuff from Amazon...they work in GMT, it's causing a fair bit of brainache becuase my PC time is set to British Summer Time (which is presently GMT + 01:00hr), so I need a slick way of converting between BST to GMT in VBA
I found this thread on an excel forum...
http://www.mrexcel.com/forum/excel-questions/417620-how-check-datetime-gmt-bst.html
...where someone actually posted a VBA function - but I couldn't quite figure out how to deploy it! (anyone?) Someone also posted this...
"If you want to convert BST to GMT you need to subtract an hour. Given that BST runs from 01:00 on the last Sunday in March to 01:00 on the last Sunday in October you can use this formula to subtract an hour from a "datetime" in A2 when required or leave alone if it's already BST."....
=IF(A2="","",A2-IF(PRODUCT(A2-DATE(YEAR(A2),{4,11},1-WEEKDAY(DATE(YEAR(A2),{4,11},0)))-1/24)<0,1)/24)
Can anyone convert the above formula in an Access "IF" statement format (it's beyond me!)
I found this thread on an excel forum...
http://www.mrexcel.com/forum/excel-questions/417620-how-check-datetime-gmt-bst.html
...where someone actually posted a VBA function - but I couldn't quite figure out how to deploy it! (anyone?) Someone also posted this...
"If you want to convert BST to GMT you need to subtract an hour. Given that BST runs from 01:00 on the last Sunday in March to 01:00 on the last Sunday in October you can use this formula to subtract an hour from a "datetime" in A2 when required or leave alone if it's already BST."....
=IF(A2="","",A2-IF(PRODUCT(A2-DATE(YEAR(A2),{4,11},1-WEEKDAY(DATE(YEAR(A2),{4,11},0)))-1/24)<0,1)/24)
Can anyone convert the above formula in an Access "IF" statement format (it's beyond me!)
