Universe FirstDay of PreviousWeek & LastDay of CurrentW

[system]

Hi All,

How are you. I am trying to achieve.BO Universe First Day of Previous Week,Last Day of Current Week,Last Day of Previous Week

Struggling to get weekly ones,appreciate your inputs
FirstDayofLastWeek
=RelativeDate(getdate();-DayNumberOfWeek(getdate())-7)

FirstDayofCurrentWeek
=RelativeDate(getdate();-DayNumberOfWeek(getdate()))

I have done for Monthly its working fine

WORKING

Start of Previous Month (date)
dateadd(m,-1,cast(convert(char(7),getdate(),23)+’-01’ as datetime))

Start of Current Month
cast(convert(char(7),getdate(),23)+’-01’ as datetime)

I have done for Monthly but struggling get Weekly

appreciate your inputs
Thanks

---

bobdude247 (BOB member since 2013-12-12)

[system]

Hi,

A post in this older topic can help:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

HI Marek,

Thanks for the link,will work on it, actually I am working on SQL Server environment

Thanks
Chandra

---

bobdude247 (BOB member since 2013-12-12)