Date Issue

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113445 More actions · Answer 1

You need to do a condition where Date >= FromDate and Date <= ToDate

DECLARE @Table TABLE (FromDate DATETIME, ToDate DATETIME, ResultDate DATETIME)

INSERT INTO @Table VALUES

('2012-01-01','2012-03-31','2011-12-31'),

('2012-04-01','2012-06-30','2012-03-31'),

('2012-07-01','2012-09-30','2012-06-30'),

('2012-10-01','2012-12-31','2012-09-30')

SELECT

ResultDate

FROM

@Table

WHERE

GETDATE() >= FromDate

AND

GETDATE() <= ToDate

ningaraju.n SSCrazy Points: 2322 More actions · Answer 2

Thanks,

But the thing is it works for only current year and the input date can be last year date.

for example input date '2010-07-06'(6th July 2010) then output should be 30.06.2010.

Ant-Green SSC Guru Points: 113445 More actions · Answer 3

Then I suggest you build a table which houses all the different probabilities

Ajay.Kedar Old Hand Points: 329 More actions · Answer 4

hi, You can write a query like

select Case When Month(getdate()) <=3 Then '31-03-'+ Convert(Varchar(4),Year(GetDate()))

When Month(getdate()) > 3 AND Month(getdate()) <=6 THEN '31-06-' + Convert(Varchar(4),Year(GetDate()))

When Month(getdate()) > 9 AND Month(getdate()) <=9 THEN '31-09-' + Convert(Varchar(4),Year(GetDate()))

ELSE '31-12-' + Convert(Varchar(4),Year(GetDate())) END

this will return you the expected result

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Simple:

declare @ThisDate datetime;

set @ThisDate = getdate();

select @ThisDate, dateadd(qq, datediff(qq, 0, @ThisDate), -1);

set @ThisDate = '20120507';

select @ThisDate, dateadd(qq, datediff(qq, 0, @ThisDate), -1);

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

If you want to see some more date calculations, look here: