I have 2 editable Date/Time Calendar control fields in a form that lets users sign out of the office for several days at a time. They have requested that a Calendar view be used so they can see at a glance who is out when. The calendar view will only show a document for the beginning date, not the end date, nor any dates in between. I was told that @Explode would help, possibly in a computed field, but I cannot make that work either. Can anyone help me?
Subject: @Explode and Calendar View
Hello
If you create a calendardatetime field, computed with a formula such as:
@TextToTime(@Explode(@TextToTime(@Text(StartDate) + “-” + @Text(EndDate))))
You can then display all these dates in a calendar view. Make sure you have the “show multiple values as separate entries” option checked in the column properties (second tab).
Hope this helps
Subject: RE: @Explode and Calendar View
Mark,
THAT DID IT!!!
Thank you so much for your input. It was the second @TexttoTime I was missing. Thanks again!!