year date not come complete

[#1]

Dears,

i need you help very urgently please ...

i 'm working in developer 1 exercise every thing working fine but i have one issue which i did'not able to understad.

or to achive .

Master Calendar.

i applied the master calendar code but only showing me years of (2007,2008) and not all years which inculded in the dates

(2004,2005,2006,2007,2008,2009)

the question is why it's omitted the all these years ..

Regards

Abdalla

[pover]

Abdalla,

Copy your script here to review it. Thanks.

Regards, Karl.

[#3]

HI ,

HERE MY SCRIPT

LET

varMinDate = Num(Peek ('OrderDate',0,'Orders'))

;

LET

varMaxDate = Num(Peek('OrderDate',-1,'Orders'))

;

LET

varToday = Num(Today())

;

//*************** Temporary Calendar ***************

TempCalendar:

LOAD

$(varMinDate)

+ rowno() - 1 AS DateNumber

,

date

($(varMinDate) + rowno() - 1)

AS

TempDate

AUTOGENERATE

$(varMaxDate)

- $(varMinDate) + 1;

MasterCalendar:

LOAD

TempDate

AS OrderDate

,

Week

(TempDate) AS Week

,

Year

(TempDate) AS Year

,

Month

(TempDate) AS Month

,

Day

(TempDate) AS Day

,

Weekday

(TempDate) AS WeekDay

,

'Q'

& Ceil(Month (TempDate)/3) AS Quarter

,

Date

( Monthstart (TempDate), 'MMM-YYYY') AS MonthYear

,

Week

(TempDate) & '-' & Year (TempDate) AS WeekYear

,

Inyeartodate

(TempDate, $(varToday), 0)*-1 AS CurYTDFlag

,

Inyeartodate

(TempDate, $(varToday), -1)*-1 AS

LastYTDFlag

Resident

TempCalendar

Order

by TempDate

ASC;

Drop

Table

TempCalendar;

[#4]

HI ,

HERE MY SCRIPT

LET

varMinDate = Num(Peek ('OrderDate',0,'Orders'))

;

LET

varMaxDate = Num(Peek('OrderDate',-1,'Orders'))

;

LET

varToday = Num(Today())

;

//*************** Temporary Calendar ***************

TempCalendar:

LOAD

$(varMinDate)

+ rowno() - 1 AS DateNumber

,

date

($(varMinDate) + rowno() - 1)

AS

TempDate

AUTOGENERATE

$(varMaxDate)

- $(varMinDate) + 1;

MasterCalendar:

LOAD

TempDate

AS OrderDate

,

Week

(TempDate) AS Week

,

Year

(TempDate) AS Year

,

Month

(TempDate) AS Month

,

Day

(TempDate) AS Day

,

Weekday

(TempDate) AS WeekDay

,

'Q'

& Ceil(Month (TempDate)/3) AS Quarter

,

Date

( Monthstart (TempDate), 'MMM-YYYY') AS MonthYear

,

Week

(TempDate) & '-' & Year (TempDate) AS WeekYear

,

Inyeartodate

(TempDate, $(varToday), 0)*-1 AS CurYTDFlag

,

Inyeartodate

(TempDate, $(varToday), -1)*-1 AS

LastYTDFlag

Resident

TempCalendar

Order

by TempDate

ASC;

Drop

Table

TempCalendar;

[ashfaq_haseeb]

HI AbdullahKn

Find the script below

let

varMinDate = num (peek('OrderDate',0,'Orders'))

;

let

varMaxDate = num (peek('OrderDate',-1,'Orders'))

;

let

varToday = num (today())

;

TempCalender:

Load

$(varMinDate)

+ rowno() -1 as DateNumber

,

date

($(varMinDate) + rowno() -1) as

TempDate

autogenerate

$(varMaxDate)-$(varMinDate) +1

;

MasterCalender:

load

TempDate

as OrderDate

,

week

(TempDate) as Week

,

year

(TempDate) as Year

,

Month

(TempDate) as Month

,

Day

(TempDate) as Day

,

'Q'

& ceil(Month(TempDate)/3) as

Quater

Resident

TempCalender

order

by TempDate

asc;

drop

table

TempCalender;

[#6]

HI BRO,

IT'S SAME LIKE THE FIRST ONE SHOWING ONLY 2007,2008

Regards,

Abdalla.

[pover]

Did you do an Order by OrderDate of the Orders table before asigning the values in varMinDate and varMaxDate?

Regards.