Date Prompt and Condition in Query Filter Pane

[system]

Hi,

I have a situation wherein I need to get the date from the user for my report ( Date Prompt).

I do create a date prompt and make the sure to supply the date for the report.

Based on the date supplied by the user I need to have filter conditions like

Transaction Process Date Between ( First Day of the month of the Report Date Prompt) and ( Last Day of tne month of the report date prompt ) .

How would I achieve this as I need to make the filter based on the report date prompt value supplied ( formulating the first day and last day of the month of the report date prompt).

Thank You,
Dpad

---

dpad (BOB member since 2010-05-10)

[system]

Hi,

Which database do you use? The syntax depends on it.

---

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

[system]

I use SQL Server 2005 as my database.

---

dpad (BOB member since 2010-05-10)

[system]

Then this sticky topic will 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)