Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create a biweekly filter pane? And who would I set the stop and start days?
What's a biweekly filter pane?
I was hoping I could add it to my app and match the weeks to my payroll which is biweekly
Robert, Bi weekly means - You want to show 45 Days Data / 15 Days Data?
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
Marco,
Can you explain what it returns?
Dual(DayName(Floor(Date,14,2)) &' - '& DayName(Floor(Date,14,2)+13),DayName(Floor(Date,14,2)))
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
Hi,
Can you please explain further or does marcowedel post helps for your requirement I believe.
Thanks marcowedel for post and info.
-Hirish