How to add a Time dimension?

[#1]

I want to add three list boxes with Year,Month and Day. Is there any in built functionality

[#2]

check this post http://www.quickqlearqool.nl/?p=160

example one should do the trick.. make sure you manually replaces al the 'qoutes' .. see last comments in the post!

[#3]

I don't exactly know what you mean, but if you already have a date value available you can create a List Box based on an expression:

=Year(Date)

[prieper]

Hi,

would suggest to review date/time-functions in the OL-Help, there are various useful functions available: you mentioned already Year, Month, Week and - seems to be more useful - Quartername, Monthname, Weekname are pretty useful in listboxes

HTH

Peter

[Anonymous]

A typical example:

LET Start = floor(yearstart(addmonths((today()), -36)));
LET End = floor(num(yearend(addmonths((today()), 36))));
LET NumOfDays = End-Start+1;
Date_src:
LOAD
 $(Start)+rowno()-1 as DateID
AUTOGENERATE NumOfDays;
Date:
LOAD
 DateID,
 date(DateID) as Date,
 day(DateID) as Day,
 week(DateID)as Week,
 month(DateID) as Month,
 dual(month(DateID) & '-' & right(year(DateID),2),
 year(DateID) & num(month(DateID), '00')) as MonthYear,
 year(DateID) as Year,
 weekday(DateID) as Weekday,
 if(weekday(DateID)>4, 0, applymap('HolidayMap',left(date(DateID),5),1)) as WorkDay
RESIDENT Date_src;
DROP TABLE Date_src;

Regards,
Michael

[#6]

Thanks a lot Michael!