if [value]>4 and [value]<8 then ksdfbgskdjfhsk end
Maybe something like this?
I dont know when daylight savings time (DST) starts and ends...
I think tableau keeps datetime records as one dimension...
Converted GMT Time:
if DateTime_Variable< DST_START AND Date_Variable > DST_END then dateadd('hour',5,[DateTime_Variable])
else DateTime_Variable>= DST_START AND Date_Variable <= DST_END then dateadd('hour',6,[DateTime_Variable])
You don't need year in there - I believe this works:
if (datepart('day',[Order Date])-datepart('weekday',[Order Date])<7 and datepart('month',[Order Date])=3)
or (datepart('day',[Order Date])-datepart('weekday',[Order Date])>=0 and datepart('month',[Order Date])=11)
or datepart('month',[Order Date])<3 or datepart('month',[Order Date])>11
then "No" else "Yes" end
No could be replaced with 6/24 or 5/24 for Yes if you are using fractional times, then add this to your time (or datetime). This does not account for the fact that the actual time of change is 2AM Sunday, and won't work historically of course.
My post was a joke and i didn't think it would be taken the wrong way but I apologize if anyone took it the wrong way.
Hub, thanks for both clarifying, and taking it down. I really do appreciate it.
Edit: Weird hearing myself say these words because I'm so NOT a PC guy. Oh well maybe just a mood.
Message was edited by: Shawn Wallwork
Not at all Hub. I didn't read it that way at all. I was actually interested in trying to get the logic for the actual DST move - weekdays and dates still confuse me.
Shawn, I would guess it was having to listen to my accent on today's TDT call....
Actually its probably having to use a PC when using tableau. hope a mac version comes out soon for Shawn.
Must say this totally threw me! I'm thinking American, and you show up to TDT with that wonderful non-Yank accent...suddenly I'm in a conversation with the characters from the 'Hour'!
Tableau, you do bring the world together!