Date Parameters

[system]

Hi,

I am having a SQL Server database universe.

I need to create the First day of Prev Month from Sysdate and Last day of Prev Month from Sysdate. Could someone kindly let me know the formula?

Also i would like to create an object which compares two objects and gives value Yes (if equal) or No (if not equal).

Thanks

---

sabitha (BOB member since 2010-02-18)

[system]

1. Have a look at the stickies at the top of the forum for lots of date codes.

2. case when A=B then ‘Yes’ else ‘No’ end

Debbie

---

Debbie (BOB member since 2005-03-01)

[system]

Hi,

This will help you:

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)

[MarkP]

@sabitha

Hi,

I am having a SQL Server database universe.

Also i would like to create an object which compares two objects and gives value Yes (if equal) or No (if not equal).

Thanks

Use a case statement:

CASE WHEN a=b then 'Yes' ELSE 'No' END

At the report level, use an if statement:

=If([object a]=[object b];"Yes";"No")