Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #9126

Re: calc first business day of month

From "Ron Paii" <None@none.com>
Newsgroups comp.databases.ms-access
Subject Re: calc first business day of month
Date 2014-03-12 12:42 -0500
Organization A noiseless patient Spider
Message-ID <lfq69p$l1b$1@dont-email.me> (permalink)
References <a2d838e8-37a2-4ecd-97ea-ab6de0c16661@googlegroups.com>

Show all headers | View raw


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. 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


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