Forum Discussion

SamuelGorgonio's avatar
SamuelGorgonio
New Contributor II
3 years ago
Solved

Reporting on Time from Application tables

I noticed that the application tables have an odd time format in column called timeid   is there another table that houses the times in 2023M3 format or is there a way to convert this colu...
Dashboards
  • ckattookaran's avatar
    ckattookaran
    3 years ago

    You must use a data table edit method to get the correct time. Use SQL to get the datatable, then do something like

    datatable.Columns.Add("TimeName")
datatable.Columns("TimeName").ReadOnly = False
datatable.Columns("TimeName").MaxLength = -1

For each dr as DataRow in datatable.rows
dr.BeginEdit
dr("TimeName") = TimeDimHelper.GetNameFromId(dr("TimeId")
dr.EndEdit
Next

     that should get you what you are looking for.

ckattookaran's avatar
ckattookaran
VIP
3 years ago

You must use a data table edit method to get the correct time. Use SQL to get the datatable, then do something like

datatable.Columns.Add("TimeName")
datatable.Columns("TimeName").ReadOnly = False
datatable.Columns("TimeName").MaxLength = -1

For each dr as DataRow in datatable.rows
dr.BeginEdit
dr("TimeName") = TimeDimHelper.GetNameFromId(dr("TimeId")
dr.EndEdit
Next

 that should get you what you are looking for.