calculate day

  • Thread starter Thread starter Irene
  • Start date Start date
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!
 
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)
 
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...
 
You must log in or register to reply here.

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

Network Days 3
Calculated field 5
Time in calculated field for shifts going past midnight 0
Creating an update query that uses multiple parameters 2
Complex query 0
Days in part of the month 1
Date calculation on 2 fields 5
calculate day from date 3

Back
Top