08-16-2024 03:21 PM
Using this function:
'Get Workflow Year
Dim myWorkflowUnitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si)
Dim wfYear As Integer = BRApi.Finance.Time.GetYearFromId(si, myWorkflowUnitPk.TimeKey)
Dim dt As New DataTable
dt.Columns.Add("Display")
dt.Columns.Add("Value")
dt.Rows.Add("Jan", "1/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Feb", "2/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Mar", "3/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Apr", "4/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("May", "5/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Jun", "6/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Jul", "7/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Aug", "8/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Sep", "9/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Oct", "10/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Nov", "11/1/" & wfYear & " 12:00:00 AM")
dt.Rows.Add("Dec", "12/1/" & wfYear & " 12:00:00 AM")
Return dt
Selection looks as:
and need it to be:
and save as 6/1/year 12:00:00am rather than the date selected.