Jump to content

Display a schedule of appointments


lonesomejubilee
 Share

This topic is 5679 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi I have a Table in which the person chooses an appointment by time of day (1-2, 2-3, etc). . . broken into categories. How would I display a nice report of that? I want to make it so that one sheet would list all appointments in chronological order. For starters.. the sort doesn't work because it is tricked by the text. I can't seem to figure it out.

Link to comment
Share on other sites

The easiest approach would be to use a calculatio to convert the time ranges to an actual time result:

Left(TimeOfDay; Position(TimeOfDay; "-"; 1; 1) - 1)

Make sure the result of the calculation is Time. Now you will be able to sort your report by this calculation field. I would have used the LeftWords function to make it easier but it doesn't recognize a "-" as a word separator anymore.

Link to comment
Share on other sites

This topic is 5679 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.