Selectable Calendar Object

[#1]

Hello everyone,

I would like to see if you guys got any idea of how i can create an object like a calendar and be able to select the items inside.

Let me explain.

I got an excel database that has dates that indicate an arrival.

I need to have an object that from today's week (Week(Today())), it shows on the respective week day if i have an arrival and to be able to select it so i can show the arrival's information on an aditional text item.

It could look something like:

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
-	-	Arrival	-	-	-	-
-	-	-	-	-	-	-
Arrival	-	-	Arrival	-		-
-	-	-	-	-	Arrival	-

Then just select any arrival and have the info displayed.

I just need help on how to create the object from above.

Any ideas?

thanks

[Nicole-Smith]

What does your data from the Excel database look like?  We can give you a better example if we know how the data looks.  Can you post a small example?

[#3]

Hi Mariana,

This is sample script,

TempCalendar:

LOAD

  $(varMinDate) + rowno() - 1 AS DateNumber,

  date ($(varMinDate) + rowno() - 1) AS TempDate

AUTOGENERATE

         $(varMaxDate) - $(varMinDate) + 1;

LOAD TempDate as OrderDate,

  Week(TempDate) as Week,

  Year(TempDate) as Year,

  Month(TempDate) as Month,

  Day(TempDate) as Day,

  WeekDay(TempDate) as WeekDay,

  Chr(81)& Ceil(Month(TempDate)/3) as Quarter,

  QuarterName(TempDate) as QuarterName,

  QuarterStart(TempDate) as QuarterStart,

  QuarterEnd(TempDate) as QuarterEnd,

  MonthName(TempDate) as  MonthName,

  MonthsName(3,TempDate) as MonthsName,

  MonthStart(TempDate) as MonthStart,

  MonthEnd(TempDate) as MonthEnd,

  WeekYear(TempDate) as WeekYear,

  Week(TempDate) & '-' & Year(TempDate) as WeakYear1,

  InYear($(varToday),TempDate,1) as Inyear,

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

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

  $(varToday) as Today

  Resident TempCalendar

  Order by TempDate asc;

[#4]

It contains a Date column, of the arrival, and more columns with info (quant, name, description, etc) thats gonna be displayed after the selection. There's no unique ID.

The date have the year its just the displayed format.

[#5]

I think this is like a Table asociating the Date with a Calendar object in the scirpt.

I was looking for something to order the arrivals in an user friendly object for selecting.

I'm just not sure on how to build this object to display what i need.

[Nicole-Smith]

Do you really need to display it like you have above, or is a list box that only shows dates from the current week and the day of the week it falls on enough (see attached for full example)?

If you need it like you have above, I'm not sure of a simple way to do it.  It seems like you would need to hack something up in order to get what you want.