Date Function - Weekday Starts on Saturday

[qberta01]

Can anyone tell me how I would express this SQL code into cognos code?

Dateadd(day, 1-datepart(dw,DATEADD(day, 1,posdate)),DATEADD(day, 1,posdate)) as IssueWeek


thx,

Q.

 

[blom0344]

You need to use the _day_of_week() Cognos function to handle the T-SQL expression of datepart(dw,[somedate])

date_add is then replaced by the Cognos _add_days() function.

Example:

dateadd(day,1,posdate)

will become:

_add_days(1,[posdate])

Ties Blom