04-25-2023 11:25 AM - last edited on 05-24-2023 12:06 PM by JackLacava
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?
Solved! Go to Solution.
04-25-2023 04:55 PM
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.
04-25-2023 04:55 PM
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.