Computing.Net > Forums > Database > access date query

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

access date query

Reply to Message Icon

Name: iso96
Date: June 20, 2007 at 07:57:45 Pacific
OS: xp pro
CPU/Ram: P4
Comment:

hello all,

i am trying to find the the last friday of the present month. I am using the following which gives me the last day of each month:

DateSerial(Year(Date()), Month(Date()) + 1, 0)


Hope someone can help, maybe im going about it wrong with the above!

Thanks for looking

iso



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: June 21, 2007 at 07:33:41 Pacific
Reply:

Might this help?

http://office.microsoft.com/en-us/a...


Life is more painless for those who are brainless.


0

Response Number 2
Name: iso96
Date: June 22, 2007 at 15:40:00 Pacific
Reply:

thanks for that - i ve done it a different way after realising that the last friday of the month wouldnt work for what im doing.



0

Response Number 3
Name: pingy
Date: July 3, 2007 at 15:26:15 Pacific
Reply:

Just a hint for people working with "end of the month issues":

The last day of a month is the first day of the next month - 1


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


SQL2000 Job Problems automatically fill relate...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: access date query

Access Date Query www.computing.net/answers/dbase/access-date-query/733.html

summarising in access-using query www.computing.net/answers/dbase/summarising-in-accessusing-query/146.html

Access 2000 query www.computing.net/answers/dbase/access-2000-query/232.html