system
#1
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
#2
-
Have a look at the stickies at the top of the forum for lots of date codes.
-
case when A=B then ‘Yes’ else ‘No’ end
Debbie
Debbie (BOB member since 2005-03-01)
system
#3
Hi,
This will help you:
Marek Chladny (BOB member since 2003-11-27)
MarkP
#4
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")