calculate day

I

Irene

i want to make a query that calculate the day. can anybody tell me how to
calculate how many days still left from now til end of the month. thanks!
 
A

Allen Browne

The last day of this month is:
DateSerial(Year(Date()), Month(Date()) + 1, 0)

So the number of days left is:
Date() - DateSerial(Year(Date()), Month(Date()) + 1, 0)
 
I

Irene

yes, it works! Thanks a lot.

Allen Browne said:
The last day of this month is:
DateSerial(Year(Date()), Month(Date()) + 1, 0)

So the number of days left is:
Date() - DateSerial(Year(Date()), Month(Date()) + 1, 0)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an update query that uses multiple parameters 2
calculate day from date 3
Days in part of the month 1
Network Days 3
Calculate interest amount based on average daily balance 1
To calculate Day Count (Monday,Tuesday etc) in month in MS Access 2
calculate two dates 1
grouping quarters 3

Top