Forum Discussion
Helper IIIDate time showing issue...
nisha_deepak If Utc DateTime is a column in your report, you'll want to reference that column in the function, not just UtcNow(), for example, click New Custom Column, then enter this formula, replace [Utc DateTime] with the name of your datetime column
=DateTime.AddZone([Utc DateTime], -6)
Helper IIIhi,
currently utc datetime value is showing as column value in my report.I want to change utc to american chicago date time value in my report as column.Now i added a custom column with DateTimeZone.SwitchZone(DateTimeZone.UtcNow(), -6 ) like this,,,Is this correct.
Community Championnisha_deepak If Utc DateTime is a column in your report, you'll want to reference that column in the function, not just UtcNow(), for example, click New Custom Column, then enter this formula, replace [Utc DateTime] with the name of your datetime column
=DateTime.AddZone([Utc DateTime], -6)