|
Go
![]() |
New
![]() |
Search
![]() |
Notify
![]() |
Tools
![]() |
Reply
![]() |
|
|
Member |
I have some simple date calcs in a define but need to show both in calendar & business days. Has anyone done business day calculations?
|
||
|
|
Gold member |
Not sure exactly what your doing in your calculations but if you were adding using DATEADD
then it would be DATEADD(DATE1, 'BD', 1); BD represents business day which can be configured by using the SET method. To see what are business days ? SET BUSDAYS (i think the default is M-F) SET BUSDAYS = '_MTWTF_'; either have the first letter of the day or an underscore if its not a business day. If you wanted to include Saturday as a business day then it would be SET BUSDAYS = '_MTWTFS'; Hopefully its what your looking for, Leo |
|||
|
|
Member |
Thanks Leo. I had a bit of a brain freeze. I got it using DATEDIF.
|
|||
|
| Previous Topic | Next Topic | powered by eve community |
| Please Wait. Your request is being processed... |
|

