By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,913 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,913 IT Pros & Developers. It's quick & easy.

calculate the time between todays date and booking date

P: 1
hi, i need to make a calculation that calculates the current length of stay for people in a hotel. so i need to take todays date from the day they booked in, any ideas?
May 15 '07 #1
Share this Question
Share on Google+
1 Reply

P: 1
Hi Becki,

You could try the DateDiff function by opening a new query in design view and enter the following into a query column;

Stay_Duration: DateDiff('d',[Date_Checked_In],[Date_Checked_Out])

You will of course need to change the "Date_Checked_In" and "Date_Checked_Out" field names to match your field names.

The result will be the whole number of days between the two dates.
May 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.