Date Functions

[rkiss]

Hi, I would like to know the equivalent Cognos 8BI expression for the following MS SQL query:


SELECT convert(varchar(10), dateadd(d, 1 - datepart(w, getdate()), getdate()), 101) AS last_sunday

The above sql query will return the date of last Sunday on any given day of the week.


Thank you,

Roman

 

[rkiss]

Here is the answer:

_add_days(current_date,-1*(_day_of_week(current_date,8)))