Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #9130
| From | "Ron Paii" <None@none.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: calc first business day of month |
| Date | 2014-03-12 14:10 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <lfqbfk$vnm$1@dont-email.me> (permalink) |
| References | <a2d838e8-37a2-4ecd-97ea-ab6de0c16661@googlegroups.com> <lfq69p$l1b$1@dont-email.me> <a0e13c4a-e15b-40b5-a9a8-d672114b7289@googlegroups.com> |
datevalue(dateadd("d",vbmonday-weekday(dateserial(year(now),month(now),1)),dateserial(year(now),month(now),1)))
"bobh" <vulcaned@yahoo.com> wrote in message
news:a0e13c4a-e15b-40b5-a9a8-d672114b7289@googlegroups.com...
> On Wednesday, March 12, 2014 1:42:15 PM UTC-4, Ron Paii wrote:
>> datevalue(dateadd("d",2-weekday(now),now)) "bobh" <vulcaned@yahoo.com>
>> wrote in message
>> news:a2d838e8-37a2-4ecd-97ea-ab6de0c16661@googlegroups.com... > Hi All, >
>> > Anyone have vba code(they would share) that calculates the date of the
>> > first business day of a given month? > thanks > bobh.
>
> thanks for the quick reply and code but, this returns the Monday date of
> the current week your in. I was looking for the first business day date
> for the current month I'm in.
> bobh.
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
calc first business day of month bobh <vulcaned@yahoo.com> - 2014-03-12 09:38 -0700
Re: calc first business day of month bobh <vulcaned@yahoo.com> - 2014-03-12 10:21 -0700
Re: calc first business day of month Neil <xxx@gmail.com> - 2014-03-12 16:26 -0500
Re: calc first business day of month "Ron Paii" <None@none.com> - 2014-03-12 12:42 -0500
Re: calc first business day of month bobh <vulcaned@yahoo.com> - 2014-03-12 12:02 -0700
Re: calc first business day of month "Ron Paii" <None@none.com> - 2014-03-12 14:10 -0500
Re: calc first business day of month "Ron Paii" <None@none.com> - 2014-03-12 14:21 -0500
Re: calc first business day of month Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-03-13 08:38 -0700
Re: calc first business day of month kduc <kduc@numerifil.invalid> - 2014-03-13 17:22 +0100
Re: calc first business day of month Patrick Finucane <patrickfinucanetx@gmail.com> - 2014-03-13 09:41 -0700
Re: calc first business day of month "Phil" <phil@stantonfamily.co.uk> - 2014-03-13 18:40 +0000
csiph-web