Link to home
Start Free TrialLog in
Avatar of WhiteLotus
WhiteLotus

asked on

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

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...

ASKER CERTIFIED SOLUTION
Avatar of HemanthaKumar
HemanthaKumar

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of WhiteLotus
WhiteLotus

ASKER

i'll try I was close but couldn't make that working out :

@explode(@Date(@Text(staff_in_date) + " - " + @Text(staff_out_date))
My god, it' so good !

You saved my evening , big kiss from my wife !

And very thanks for the quick & efficient answer.


Efficient one. thanks a lot
You are welcome.
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 ?
time was missing.

datelist:=@Explode(@TextToTime(@Text(Staff_in_date) + "-" + @Text(staff_out_date)));
@TextToTime(@Text(DateList) + " " + @Text(staff_in_h))
Time was missing ! Did that fix the problem ?
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.