subject:"RE\: SQL quickie"

RE: SQL quickie SOLVED

2003-07-07 Thread Eric Creese

Thanks to everyone who replied so promptly. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 7:29 AM To: CF-Talk Subject: RE: SQL quickie if you are on SQL 2000 this is a UDF which sort this out.. CREATE FUNCTION dbo.LastMonthDay

RE: SQL quickie

2003-07-07 Thread webguy

There is a good series on using MS-SQL date functions here http://www.databasejournal.com/features/mssql/article.php/2191631 -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:22 To: CF-Talk Subject: SQL quickie I want to be able to take a value of g

RE: SQL quickie

2003-07-07 Thread Robertson-Ravo, Neil (RX)

if you are on SQL 2000 this is a UDF which sort this out.. CREATE FUNCTION dbo.LastMonthDay ( @Date datetime ) RETURNS datetime AS BEGIN RETURN (CASE WHEN MONTH(@Date)= 12 THEN DATEADD(day, -1, CAST('01/01/' + STR(YEAR(@Date)+1) AS DateTime)) ELSE DATEADD(day, -1, CAST(STR(MONTH(@Date)+1) + '/0

RE: SQL quickie

2003-07-07 Thread DURETTE, STEVEN J (AIT)

Try: declare @myCurrDate datetime declare @myEOM datetime set @myCurrDate = getdate() set @myEOM = dateadd(d, -(day(dateadd(m, 1, @myCurrDate) + 1)), dateadd(m, 1, @myCurrDate)) Steve -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 8:22 AM To