Counting Days
I am having a difficult time in figuring out how to do this... Associates have their hotel length of stay recorded in two fields "Hotel Check-In Date" and "Hotel Check-Out Date" One of the functions...
Forum Discussion
Evan,
The 2nd example is closer to what is needed.
If I was going to lay it out it would be something like this...
------------------------------
Hans Hamm
------------------------------
The 2nd example is closer to what is needed.
If I was going to lay it out it would be something like this...
| Show me a count of nights for associates in hotel rooms from 10/21 thru 10/26 | |||||||||||||
| Would give me 6 nights for both Joe and Sally | |||||||||||||
| 14-Oct | 15-Oct | 16-Oct | 17-Oct | 18-Oct | 19-Oct | 20-Oct | 21-Oct | 22-Oct | 23-Oct | 24-Oct | 25-Oct | 26-Oct | |
| Joe | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Sally | X | X | X | X | X | X | |||||||
| Show me a count of nights for associates in hotel rooms from 10/14 thru 10/26 | |||||||||||||
| Would give me 13 nights for Joe 6 nights for Sally | |||||||||||||
| 14-Oct | 15-Oct | 16-Oct | 17-Oct | 18-Oct | 19-Oct | 20-Oct | 21-Oct | 22-Oct | 23-Oct | 24-Oct | 25-Oct | 26-Oct | |
| Joe | X | X | X | X | X | X | X | X | X | X | X | X | X |
| Sally | X | X | X | X | X | X | |||||||
------------------------------
Hans Hamm
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHere is a thought.
If this is a low usage situation by very few users, who need this filter. Then make a single record in a new table called Analysis Dates. it will be Record ID# 1 and it will have two date fields for Analysis Start date and Analysis End Date.
Make a relationship down to your detail records. Now you can use these date fields to either filter records or to calculate the # of days within the hotel stay period which are within the Analysis Date range.
If you like, the records can be displayed directly on the Analysis date range record as an embedded report. But if not, I suggest that you display the Analysis Date range on the report itself as Group By headers or columns so the user knows what extra date filters are being used.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
If this is a low usage situation by very few users, who need this filter. Then make a single record in a new table called Analysis Dates. it will be Record ID# 1 and it will have two date fields for Analysis Start date and Analysis End Date.
Make a relationship down to your detail records. Now you can use these date fields to either filter records or to calculate the # of days within the hotel stay period which are within the Analysis Date range.
If you like, the records can be displayed directly on the Analysis date range record as an embedded report. But if not, I suggest that you display the Analysis Date range on the report itself as Group By headers or columns so the user knows what extra date filters are being used.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- MarkShnier__You.. and if its multi user there is a solution for that too.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------