I have situation here,
Lets say we have two applications in org
App1 stores data in 'GMT format'
App2 stores data in 'UK formart'(GMT+1 from every year march last sunday to Every Year oct last sunday').
Users asking all data should be in gmt format in same graph.
So need to convert app2 data in gmt format completely without disturbing source data.
Uk times are varies as below according to GMT
In the UK the clocks go forward 1 hour at 1am on the last Sunday in March(GMT+1), and back 1 hour at 2am on the last Sunday in October(GMT Starts from this time). The period when the clocks are 1 hour ahead is called British Summer Time (BST).
I able to convert from march month to oct like below but which is not giving accuracy. Need to add time and Last sunday of March & October.
IF [Farm_Name] = 'App2' AND [Month no] >=3 AND [Month no] <=10 THEN [UKtoGMT]
here UKtoGMT was calculated by Adddate('hour',-1, window_start]).
window_start is Actul date time column.
Please help me how to find last sunday in a month.