Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to write an expression to bring back the NetworkDays for the current financial period.
I have tried NetWorkDays(Floor(MonthStart(Today())), Floor(MonthEnd(Today())))
However this brings back the days for current calendar month
Thanks
Many thanks for this. 1 slight change to get it to work:
NetWorkDays(Min({<mtd_flag = {1}>}date),
If(WeekDay(MonthEnd(Today()))='Sun',MonthEnd(today()),
If(WeekDay(MonthEnd(Today()))='Sat',Date(MonthEnd(Today())+1),
WeekEnd(MonthEnd(Today()),-1,0)))
Glad to have this one sorted
Try YearStart and YearEnd instead of MonthStart & MonthEnd.
NetworkDays(Floor(YearStart(Today())),Floor(YearEnd(Today())))
Unfortunately that will give network days for the year.
I need network days for the current financial period.
For example current month is September which starts on the 01/09/2019 how i need it to bring back the network days for period 9 which started on the 26/08/2019
=NetWorkDays(Date(MonthStart(Today())-6,'DD-MM-YYYY'),Date(MonthEnd(Today()),'DD-MM-YYYY'))
Hi,
try to add weekstart:
NetWorkDays(Floor(WeekStart(MonthStart(Today()))), Floor(MonthEnd(Today())))
Thankyou both for your assistance with this. It has got me a bit closer:
NetWorkDays(WeekStart(MonthStart(Today()),0,0), WeekEnd(MonthEnd(Today()),-1,0))
This works for the current period however it will be incorrect if the last day of the period is the last or first day of a calendar month.
Hi,
try adding these condition:
NetWorkDays(WeekStart(MonthStart(Today()),0,0), If(WeekDay(MonthEnd(date))='Sun',MonthEnd(date),
If(WeekDay(MonthEnd(date))='Sat',Date(MonthEnd(date)+1),
WeekEnd(MonthEnd(date),-1,0)))))
Many thanks for this. 1 slight change to get it to work:
NetWorkDays(Min({<mtd_flag = {1}>}date),
If(WeekDay(MonthEnd(Today()))='Sun',MonthEnd(today()),
If(WeekDay(MonthEnd(Today()))='Sat',Date(MonthEnd(Today())+1),
WeekEnd(MonthEnd(Today()),-1,0)))
Glad to have this one sorted