rkiss
Programmer
- Jun 2, 2006
- 9
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
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