Can Any one helpme with logic for fortnight

[Former Member]

Hi All,

I need the logic for Fortnight of the year for drill in reports . Can any one help me regarding this.

Thanks in Advance

[Former Member · Accepted solution]

Hi,

I have built this logic to display the fortnights of current month plz modify this according to you requirmenet.

Here is the query....

SELECT case when getdate() between DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)

and

dateadd(dd,14,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) ) then 'Fnight-1' else 'Fnight-2' end

Cheers,

Ravichandra K