calendar day

[Julie845]

I have a calendar view with a text list field. The view is fine working,
I have a from and a to dates, the system creates item the list like
09/01/2004
09/02/2004
09/03/2004
09/04/2004
09/05/2004
I have to produce an icon based on the day
09/01/2004 (icon 112 a blue -->)
09/02/2004 (icon 117 a blue .)
09/03/2004 (icon 117)
09/04/2004 (icon 117)
09/05/2004 (icon 111 a blue <--)
How can I check if the calendar date is the first of my list or not ?

Thanks

Julie

 

[pmonett]

If I understand correctly, you have to have a view icon that changes once a day for the duration of whatever project is being tracked.
Since it is a view icon, you have to use formulas.
So I would suggest the following procedure :

1) check if todays date is contained in the list, if not, no icon.
2) check if todays date is equal to from date or to date and if so, display start or end icon.
3) otherwise, display blue dot icon.

In code, this would be something like this :

datetoday := @today;
@if(@contains(datelist;datetoday);
     @if(datetoday=fromdate;112;
         datetoday=todate;111;
         117);
    0)

I think this should put you on the right track. Good luck !

Pascal.

 

[Julie845]

Pascal

My problem is link with my daylist, to have it correctly displayed on different item, I use the "show multiple values as seperate entries" option.
I don't know where and how the system stores the date information to manage this option.

With the code, I have only a blue --> with 09/09/2004
because we are using @today to make the test.
I'm trying to find the date field used by the system to manage calendar view
Have you any idea how and where I could find this ?

thanks

Julie

 

[pmonett]

The field used to place a calendar doc in the correct place is CalendarDateTime.
Now I get it, you want the calendar to list different icons per day listed, not following the day it is. Like, you create a doc spanning Monday to Thursday, and you want the calendar to show Monday with the -> icon, Tuesday and Wednesday with the blue. and Thursday with the <- icon.
That you cannot do with a single document. You will need to review your creation process and make one different document per day, and assign the icon in each document. The icon cannot have multiple values for a single document.

Pascal.