Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
source.ACTIVITY_MM | source.ACTIVITY_YYYY |
---|---|
01 | 2013 |
02 | 2013 |
03 | 2013 |
04 | 2013 |
05 | 2013 |
06 | 2013 |
07 | 2013 |
08 | 2013 |
You can use makedate() function instead of date#() date interpretation, which should make things much simpler:
=NetWorkDays(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM),
if(text(GetFieldSelections(source.ACTIVITY_MM))=text(Date(ReloadTime(),'MM')),
ReloadTime(),
monthend(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM)))
)
You can use makedate() function instead of date#() date interpretation, which should make things much simpler:
=NetWorkDays(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM),
if(text(GetFieldSelections(source.ACTIVITY_MM))=text(Date(ReloadTime(),'MM')),
ReloadTime(),
monthend(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM)))
)
Working fine.
Thanks.