Skip to Content
0
Former Member
Sep 25, 2008 at 09:44 AM

converting date parameter to week no. and year

23 Views

i have created two parameters ?WeekNo and ?YearNo using one date field from my table, the first one i need to convert it to weeks and the other one to years and in my formula i need to create something like:

if {table.field} <> 0 then

select count(*) from table

where table.Datefield = ?WeekNo and table.Datefield = ?YearNo / select {table.field} from table

how do i get a workaround that?