Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

converting date parameter to week no. and year

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?

replied

You can get this by writing the following formula :

If = 0 Then

if datepart("ww",datefield) = ?WeekNo and Year(Datefild)=?YearNo Then

Count(table.field)

Hope this will help you.

Thanks,

Sastry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question