count nr of days

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 09 Nov 2006 11:05 GMT

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.

Reply to this Message

Graham R Seach - 09 Nov 2006 11:23 GMT

Eric,

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

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

> 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.

Reply to this Message

Klatuu - 09 Nov 2006 15:37 GMT

Look in VBA Help for the DateAdd function.

> 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.

Reply to this Message