Skip to main content
S
SamuelGorgonio
Newcomer
April 25, 2023
Solved

Reporting on Time from Application tables

  • April 25, 2023
  • 1 reply
  • 0 views

I noticed that the application tables have an odd time format in column called timeid

SamuelGorgonio_0-1682436232833.png

 

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?

Best answer by ckattookaran

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.

1 reply

C
ckattookaranAnswer
Newcomer
April 25, 2023

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.

    Terms & ConditionsAccessibility statement