Hello all experts,
my problem is that I want in his function to extract the Number of Working day for the selected month.
my filed are:
| source.ACTIVITY_MM | source.ACTIVITY_YYYY |
|---|
| 01 | 2013 |
| 02 | 2013 |
| 03 | 2013 |
| 04 | 2013 |
| 05 | 2013 |
| 06 | 2013 |
| 07 | 2013 |
| 08 | 2013 |
this is my function:
=NetWorkDays(date#('01/'&source.ACTIVITY_MM&'/'&source.ACTIVITY_YYYY,'DD/MM/YYYY'),
if(text(GetFieldSelections(source.ACTIVITY_MM))=text(Date(ReloadTime(),'MM')),date(ReloadTime(),'DD/MM/YYYY')),
date#(
day(monthend(date#'01/'&max(GetFieldSelections(source.ACTIVITY_MM))&'/'&source.ACTIVITY_YYYY,'DD/MM/YYYY')))
&'/'&source.ACTIVITY_MM&'/'&source.ACTIVITY_YYYY))
For example if I chose MM=02, YYYY=2013 then the function will return 28,
if I chose MM=07, YYYY=2013 then the function will return 31,
if I chose MM=08, YYYY=2013 then the function will return 9 -( until the reload time)
Sadly it isn't working.
Any Idea?
BR
Ariel
