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

GET TOMORROW DATE in ACCESS Query

P: 1
Hi Friends

I am stuck at only one problem in the access database.

I have got the label on the form and I want that label to be run by a query.

I have created query where i have got only 2 fields. One is last Date and other one is next date.

Lets say the last date is 30/01/2007 now the problem i am having is to get the tomorrow's date which is 31/01/2007.

Does anybody know any criteria to fix this problem ?

If you do then please do reply me ASAP.

Thanks.
Jan 30 '07 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
NextDate = Dateadd("d",LastDate,1)
Jan 30 '07 #2

ADezii
Expert 5K+
P: 8,704
Hi Friends

I am stuck at only one problem in the access database.

I have got the label on the form and I want that label to be run by a query.

I have created query where i have got only 2 fields. One is last Date and other one is next date.

Lets say the last date is 30/01/2007 now the problem i am having is to get the tomorrow's date which is 31/01/2007.

Does anybody know any criteria to fix this problem ?

If you do then please do reply me ASAP.

Thanks.
Expand|Select|Wrap|Line Numbers
  1. 'The Default is to add Days to a given Date
  2. [Next Date] = [Last Date] + 1
Jan 30 '07 #3

Post your reply

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