Skip to Content
0
Former Member
Sep 29, 2008 at 07:36 AM

creating formula for parameter

39 Views

hi

i have a date field as my parameter and i need to convert it to week no and year so i created two parameters WeekNo and YearNo then i created two formulas {vw_wrkWorkOrders.CompleteByDate} = CStr(datepart("ww",{?WeekNo}),0) and {vw_wrkWorkOrders.CompleteByDate} = CStr(datepart("yyyy",{?YearNo}),0) but it's still not showing as weeks and year, the full date is displayed,

how do i do this.