Bi weekly filter pane

[#1]

Is it possible to create a biweekly filter pane?  And who would I set the stop and start days?

[maxgro]

What's a biweekly filter pane?

[#3]

I was hoping I could add it to my app and match the weeks to my payroll which is biweekly

[Anil_Babu_Samineni]

Robert, Bi weekly means - You want to show 45 Days Data / 15 Days Data?

[MarcoWedel]

Hi,

maybe something like this?

tabCalendar: 
LOAD *, 
    Day(Date) as Day, 
    WeekDay(Date) as WeekDay, 
    Week(Date) as Week, 
    WeekName(Date) as WeekName,
    Dual(DayName(Floor(Date,14,2))&' - '&DayName(Floor(Date,14,2)+13),DayName(Floor(Date,14,2))) as BiWeek,
    Month(Date) as Month,
    MonthName(Date) as MonthName, 
    Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter, 
    QuarterName(Date) as QuarterName, 
    Year(Date) as Year, 
    WeekYear(Date) as WeekYear;   
LOAD Date(MinDate+IterNo()-1) as Date 
While MinDate+IterNo()-1 <= MaxDate; 
LOAD MakeDate(2014) as MinDate, 
    Today() as MaxDate 
AutoGenerate 1;

hope this helps

regards

Marco

[Anil_Babu_Samineni]

Marco,

Can you explain what it returns?

Dual(DayName(Floor(Date,14,2)) &' - '& DayName(Floor(Date,14,2)+13),DayName(Floor(Date,14,2)))

[MarcoWedel]

Hi,

It creates consecutive 14 days intervals represented by start and end date having a numerical value of the start date. The 2 weeks / 14 days are defined in the first parameter of the Floor() function. The second parameter adds an offset to let the intervals start on mondays.

Hope this helps

Regards

Marco

[HirisH_V7]

Hi,

Can you please explain further or does marcowedel‌  post helps for your requirement I believe.

Thanks marcowedel for post and info.

-Hirish