count nr of days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to count the nr of days when reading a date mm/dd/yyyy in a
recordset? for example when reading 09/22/2006 it should put 30 into another
variable. Thanks for any help on this.
 
Eric,

SELECT Day(DateSerial(Year([somedate]),Month([somedate])+1,0)) AS MonthDays
FROM tblMyTable

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 

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

Strange Julian Date Phenomenon 9
Powerpoint VBA help 0
importing ambiguous dates 4
Issue editing a recordset 5
VBA Select query with date range format issue 2
Excel Formula - Count Dates from another Sheet 8
Set Default Date to European Format without changing Regional settingof the PC 6
Getting MM-DD HH:MM out of Julian date 4

Back
Top