|wfYear| param no longer in v8. Need to pull only months names from Bound List

ih7084
New Contributor II

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

Imane_0-1723835706496.png

Selection looks as:

Imane_1-1723835873990.png

 

and need it to be:

Imane_2-1723835895986.png

 

and save as 6/1/year 12:00:00am rather than the date selected.

 

 

 

0 REPLIES 0