?
Solved

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

Posted on 2003-04-01
9
Medium Priority
?
177 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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month9 days, 17 hours left to enroll

571 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