Second sunday of march - daylight saving time and standard time

Hi All,

I am living in asia time, so when I download the data from esignal for YM, it starts at 9:30p.m(my time) in daylight saving time while start at 10:30p.m(my time) in standard time. The time is changed in the 2nd sunday of March each year. I thought it would be something simple but I just can't make it. I tried the Month(), dayofweek()...etc function but just can't make the logic right. Hope anyone here could give me a hand, or some clues...


use $TIMESHIFT in format file

1 Like