The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

ih7084's avatar
ih7084
New Contributor II
1 year ago

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

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.

 

 

 

No RepliesBe the first to reply