Fortnight function

[#1]

Is any fortnight function available like Week,Day etc.

[Anonymous]

No but you could try something like

     round ( week ( today() ) / 2 )

[anbu1984]

=Date( today()+14 ) --Fortnight date

=Week( today()+14 ) --Fortnight week

[ashfaq_haseeb]

Hi,

Check this.

Regards

ASHFAQ

[MarcoWedel]

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