Forum Discussion

SamuelGorgonio's avatar
SamuelGorgonio
New Contributor II
2 years ago

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 column easily when using it in a SQL data adaptor?

Dashboards
  • ckattookaran's avatar
    ckattookaran
    2 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
    2 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.