Getting a percentage from data between a specified time period 1

[gscheepers]

I need to create a report that gives the user a result in a % of room occupation. The result should come from the hours of 9am and 9pm, Monday to Saturday, each month. I then need to get the percentage the room was occupied for the period/month requested.

What makes it really difficult is that ther person that initially designed the database, created the time field as a text field. I've changed the field type in the report to a number field, which means that I had to split the hours and the seconds to get rid of the colon. (ie. 09:00 now reads 900).

 

[mbarron]

If you're using CR8 or higher you don't have to alter the the time field. You can use the CTime funcion instead

CTime({time.field})





Mike

 

[gscheepers]

Thanks Mike! That surely helped a lot! I'm using CR8.5.

Gerhard Gerhard Scheepers
BA - LETEC