=DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Parameters!Date.Value))
=DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Parameters!Date1.Value))
=Fields!Date.Value
Results are: 8/21/2010 9:18:50 AM=DateAdd("h",Parameters!TimeZone.Value,Fields!Date.Value)
Result are: 8/21/2010 7:18:50 AM=DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))
The Entered Date is not correct!=Fields!Date.Value
=Dateadd("h",Parameters!TimeZone.Value,Fields!Date.Value)
=System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value)
=DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))
=Dateadd("h",Parameters!TimeZone.Value,Globals!ExecutionTime)
=DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Now()))
=DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(DateTime.Now.ToUniversalTime()))
=WeekDayName(DatePart("w",DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))))
=WeekDayName(DatePart("w",DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Now()))))
=WeekDayName(DatePart("w",DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(DateTime.Now.ToUniversalTime()))))
=DatePart("w",DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(DateTime.Now.ToUniversalTime())))
=DatePart("w",DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Now())))
=System.TimeZone.CurrentTimeZone.IsDaylightSavingTime(Fields!Date.Value)
=IIf(System.TimeZone.CurrentTimeZone.IsDaylightSavingTime(Now()),System.TimeZone.CurrentTimeZone.DaylightName,System.TimeZone.CurrentTimeZone.StandardName)
=IIf(System.TimeZone.CurrentTimeZone.IsDaylightSavingTime(DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))),System.TimeZone.CurrentTimeZone.DaylightName,System.TimeZone.CurrentTimeZone.StandardName)
=WeekDay(Fields!Date.Value)
Results are: 2 (Monday)=WeekDay(DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value)))
Results are: 1 (Sunday)=Hour(System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))
Results are: 22=Hour(DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value)))
Results are: 20=Hour(DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value)))
Results are: 7=Right(100+Hour(DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))),2)
Results are: 07=((WeekDay(DateAdd("h",Parameters!TimeZone.Value,Fields!Date.Value)) = 1 OR
WeekDay(DateAdd("h",Parameters!TimeZone.Value,Fields!Date.Value)) = 7) OR
(Hour(DateAdd("h",Parameters!TimeZone.Value,Fields!Date.Value)) >= Parameters!TimeZone.Value+19 OR
Hour(DateAdd("h",Parameters!TimeZone.Value,Fields!Date.Value)) < Parameters!TimeZone.Value+8))
=Fields!Date.Value
Results are: 8/2/2010 3:12:34 AM=Dateadd("h",Parameters!TimeZone.Value,Fields!Date.Value)
Results are:: 8/2/2010 1:12:34 AM=System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value)
Results are: 8/1/2010 10:12:34 PM=Dateadd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))
Results are: 8/1/2010 8:12:34 PM=Dateadd("h",Parameters!TimeZone.Value,Globals!ExecutionTime)
Results are: 9/20/2010 6:11:40 AM=WeekDayName(DatePart("w",Dateadd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!Date.Value))),TRUE,0)
Results are: Sunday=System.TimeZone.CurrentTimeZone.ToLocalTime(Now())
Results are: 9/20/2010 8:12:03 AM=DateAdd("h",Parameters!TimeZone.Value,System.TimeZone.CurrentTimeZone.ToLocalTime(Now()))
Results are: 9/20/2010 6:12:03 AM=Globals!ExecutionTime
Results are: 9/20/2010 8:11:40 AM="Execution Time: " +IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).TotalSeconds < 1, "0 seconds", (IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours & " hour(s), ", "") +IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes & " minute(s), ", "") +IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds & " second(s)", "")))
Results are: Execution Time: 22 second(s)=DateTime.SpecifyKind(Date.Now, DateTimeKind.Utc)
Results are: 9/20/2010 8:12:03 AM=DateTime.SpecifyKind(Date.Now, DateTimeKind.Local)
Results are: 9/20/2010 8:12:03 AM=System.TimeZone.CurrentTimeZone.ToUniversalTime(Fields!Date.Value)
Results are: 8/2/2010 8:12:34 AM=System.TimeZone.CurrentTimeZone.IsDaylightSavingTime(Fields!Date.Value)
Results are: TRUE=System.TimeZoneInfo.Utc.Id
Results are: UTC=System.TimeZoneInfo.Local.BaseUtcOffset.Hours
Results are: -6=System.TimeZoneInfo.Local.GetUtcOffset(Now())
Results are: -05:00:00=IIf(System.TimeZone.CurrentTimeZone.IsDaylightSavingTime(Now()),System.TimeZone.CurrentTimeZone.DaylightName,System.TimeZone.CurrentTimeZone.StandardName)
Results are: Central Daylight Time=System.TimeZone.CurrentTimeZone.DaylightName
Results are: Central Daylight Time=System.TimeZone.CurrentTimeZone.StandardName
Results are: Central Standard Time=weekday(today())
Results are: 2
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (0)