?
Solved

how to implement a time-ranged document in a calendar view ?

Posted on 2003-04-01
9
Medium Priority
?
176 Views
Last Modified: 2013-12-18
hello,

i'm programming in lotus 6 :

it is easy to make a calendar view.

but how to make a document (who contains a range instead of a single date) appearing several times in the calendar view.

(ex: from the 10.02.02 until the 17.02.02) on every days of the (calendar view)
whitout having to type 7 time the document for each day...

does anyone have that formula ? a view who do it ?

i just have no clue of a way out...

0
Comment
Question by:WhiteLotus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 1000 total points
ID: 8246420
In the calendar view, the first column should be enabled to show multiple value as seperate entries

First column formula would be like this

DateList := @Explode(@TextToTime(@Text(StartDateTime) + "-" + @Text(EndDateTime)));
DateList

~Hemanth
0
 

Author Comment

by:WhiteLotus
ID: 8246537
i'll try I was close but couldn't make that working out :

@explode(@Date(@Text(staff_in_date) + " - " + @Text(staff_out_date))
0
 

Author Comment

by:WhiteLotus
ID: 8246601
My god, it' so good !

You saved my evening , big kiss from my wife !

And very thanks for the quick & efficient answer.


0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:WhiteLotus
ID: 8246615
Efficient one. thanks a lot
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 8247991
You are welcome.
0
 

Author Comment

by:WhiteLotus
ID: 8251515
I still have a problem, it works in the designer's preview
but shows no entries in the client (the same calendar view).

any idea ?
0
 

Author Comment

by:WhiteLotus
ID: 8251622
time was missing.

datelist:=@Explode(@TextToTime(@Text(Staff_in_date) + "-" + @Text(staff_out_date)));
@TextToTime(@Text(DateList) + " " + @Text(staff_in_h))
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 8254564
Time was missing ! Did that fix the problem ?
0
 

Author Comment

by:WhiteLotus
ID: 8259326
Yes, even if you do not shot time in calendar the 1st column needs to have a time .

previous code is working fine.

thanks again.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question