D
ddo1
Need expresson (DateSerial?) to show last day of previous
month. Thanks for the help.
month. Thanks for the help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Brandt
ddo1 said:Need expresson (DateSerial?) to show last day of previous
month. Thanks for the help.
=DateSerial(Year(Date()), Month(Date()), 0)
D
ddo1
How about last business day of previous month? Thanks.
K
Ken Snell
Define "business day".
R
Rick Brandt
Yeah, I looked at the subject line and completely missed "business" in the body.
K
Ken Snell
No, your answer was what he asked for in the original post. His followup
extended the question. You were "spot on" in your reply.
extended the question. You were "spot on" in your reply.
D
ddo1
This was an additional inquiry.
Banking Days=Business day. Sorry, I should have created a
new post.
Thanks.
Banking Days=Business day. Sorry, I should have created a
new post.
Thanks.
K
Ken Snell
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 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)?