Showing results for 
Search instead for 
Did you mean: 

Can Any one helpme with logic for fortnight

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


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)


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


Ravichandra K

Answers (0)