Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #9149
| From | kduc <kduc@numerifil.invalid> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: calc first business day of month |
| Date | 2014-03-13 17:22 +0100 |
| Organization | Service de news de lacave.net |
| Message-ID | <lfslvs$13q7$1@talisker.lacave.net> (permalink) |
| References | <a2d838e8-37a2-4ecd-97ea-ab6de0c16661@googlegroups.com> <78bcfa7e-665c-45b4-9e1f-3a5cbcb6e182@googlegroups.com> |
Le 13/03/2014 16:38, Patrick Finucane a écrit : > On Wednesday, March 12, 2014 11:38:27 AM UTC-5, bobh wrote: >> Hi All, Anyone have vba code(they would share) that calculates the date of the first business day of a given month? thanks bobh. > > dat = Date() > ? (dat - Day(dat) + 1) + 7-Weekday(dat - Day(dat), vbMonday) Don't forget légal holidays, etc... -- kd
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