Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is any fortnight function available like Week,Day etc.
No but you could try something like
round ( week ( today() ) / 2 )
=Date( today()+14 ) --Fortnight date
=Week( today()+14 ) --Fortnight week
Hi,
Check this.
Regards
ASHFAQ
Hi,
maybe one solution could be:
SET Fortnight = Ceil(Week($1)/2);
SET FortnightName = Dual(WeekYear($1)&'/'&Num(Ceil(Week($1)/2),'00'),MakeWeekDate(WeekYear($1),Ceil(Week($1)/2)*2-1));
SET Quarter = Dual('Q'&Ceil(Month($1)/3),Ceil(Month($1)/3));
tabCalendar:
LOAD *,
Day(Date) as Day,
WeekDay(Date) as WeekDay,
Week(Date) as Week,
WeekName(Date) as WeekName,
$(Fortnight(Date)) as Fortnight,
$(FortnightName(Date)) as FortnightName,
Month(Date) as Month,
MonthName(Date) as MonthName,
$(Quarter(Date)) as Quarter,
QuarterName(Date) as QuarterName,
Year(Date) as Year,
WeekYear(Date) as WeekYear;
LOAD Date(MakeDate(2012)+IterNo()-1) as Date
AutoGenerate 1
While MakeDate(2012)+IterNo()-1<=Today();
hope this helps
regards
Marco