Skip navigation

How to convert UTC Time zone to different time zones in tableau

score 4
You have not voted. Active

if date([Date Time Stamp In]) > #14-03-2010# and date([Date Time Stamp In]) < #07-11-2010#

then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #13-03-2011# and date([Date Time Stamp In])

< #06-11-2011# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #11-03-2012# and date([Date Time Stamp In])

< #04-11-2012# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #10-03-2013# and date([Date Time Stamp In])

< #03-11-2013# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #09-03-2014# and date([Date Time Stamp In])

< #02-11-2014# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #08-03-2015# and date([Date Time Stamp In])

< #01-11-2015# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #13-03-2016# and date([Date Time Stamp In])

< #06-11-2016# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #12-03-2017# and date([Date Time Stamp In])

< #05-11-2017# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #11-03-2018# and date([Date Time Stamp In])

< #04-11-2018# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #10-03-2019# and date([Date Time Stamp In])

< #03-11-2019# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #08-03-2020# and date([Date Time Stamp In])

< #01-11-2020# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #14-03-2021# and date([Date Time Stamp In])

< #07-11-2021# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #13-03-2022# and date([Date Time Stamp In])

< #06-11-2022# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #12-03-2023# and date([Date Time Stamp In])

< #05-11-2023# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #10-03-2024# and date([Date Time Stamp In])

< #03-11-2024# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

elseif date([Date Time Stamp In]) > #09-03-2025# and date([Date Time Stamp In])

< #02-11-2025# then DATEADD('hour',8.5,[Date Time Stamp In])

 

 

else DATEADD('hour',8.0,[Date Time Stamp In])

 

end

 

 

Ramu

9741466277

kavatiramu@gmail.com

Comments

Vote history