Exp for last day of previous month

  • Thread starter Thread starter ddo1
  • Start date Start date
D

ddo1

Need expresson (DateSerial?) to show last day of previous
month. Thanks for the help.
 
ddo1 said:
Need expresson (DateSerial?) to show last day of previous
month. Thanks for the help.
Click to expand...

=DateSerial(Year(Date()), Month(Date()), 0)
 
Yeah, I looked at the subject line and completely missed "business" in the body.
 
No, your answer was what he asked for in the original post. His followup
extended the question. You were "spot on" in your reply.
 
This was an additional inquiry.

Banking Days=Business day. Sorry, I should have created a
new post.

Thanks.
 
But what is a banking day? In order for ACCESS to identify such a day(s),
you must be able to define it. Is it all Monday through Friday dates? Is it
all Monday through Friday dates except when the date is 31? Is it just
Fridays? When is a weekday not a banking day (e.g., when it's a holiday? and
if yes, then what are the list of holidays)?
 
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

Previous Month Query 5
Date - Beginning of Month 1
Query for previous week, Sun thru Sat, from date field 1
value displayed repeatedly 9
Date criteria 12
Days in part of the month 1
Need the Year Functions 1
DateSerial question 5

Back
Top