=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)