Quarterly Object

[system]

Hello All,

I have one report request in which i need to make a prompt for Quater object to see the data based on Quarter.

we have two object named start date and end date.

Start date type:10/1/2009 12:00:00 AM and so on…

End Date type:10/31/2009 12:00:00 AM and so on…

Now i want to make an object with the quarter for Start Date and End Date.

I am using SQL Server 2000.

Thanks for your help…
SH

---

SH3230 (BOB member since 2010-10-25)

[system]

Hello Guys !!

I need to pull data based on Quarterly.Using the objet Start Date and End Date.

Thanks
Sh

---

SH3230 (BOB member since 2010-10-25)

[system]

Hi,

This can get you started:

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]

Marek,

Thanks for your reply, Just want to conform this works?Correct me if i am wrong.

I have created one detail object of start date as follows.

I did not make any thing for end date.

Datepart(q, Table.column)

I have used in the Query filter as a prompt. It is showing me 2, 3 4 as quarter’s LOV.User will select the quarter based on their requirement.

Does this will accomplish the requirement to see the quarterly report.

Other wise as you have posted me the code. how am i going to make predifined filter so that user will get list of value to select based on quarter?

Start of Current Quarter
Code:
dateadd(qq,datediff(qq,0,getdate()),0)

End of Current Quarter
Code:
dateadd(qq,datediff(qq,-1,getdate()),-1)

Thanks
SH

---

SH3230 (BOB member since 2010-10-25)

[system]

Hello All,

Any thoughts on this?

Thanks

SH

---

SH3230 (BOB member since 2010-10-25)