I had this problem: how do I calculate the number of days between 2 dates?THE AHA STACK MASTERCLASS Launching May 27th In particular, I wanted to count the number of nights that a person had to pay to rent a h
instead of a discharge date the value will be "HERE" (I can change this if needed - it's just been a helpful placeholder). We report a total number of bed nights for two ranges in a month, either the 1st to the 15th, or the ...
Could you please share some sample data in table Roomnights & Reservation dates (exclude sensitive data)? Is there any relationship created between these two tables? Did you create date dimension table? On the other hand, you can refer the content in the following links to get it. ...
instead of a discharge date the value will be "HERE" (I can change this if needed - it's just been a helpful placeholder). We report a total number of bed nights for two ranges in a month, either the 1st to the 15th, or the ...
Hello, I have a table set up where I have an intake date and a discharge date as specific columns. When the patient has not yet discharged, instead of a discharge date the value will be "HERE" (I...