Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please, no cross postings. It makes it hard to follow a discussion.
Most forum users watch most of the discussion groups anyway, I think.
See your other thread a for suggested solution.