I have the following doubt, I have this function to calculate dates between 2 dates, however these dates have hours, I have been working on the function to get the decimals however I still dont get the decimals, I have tried ( Number.Round), (Decimal.From)
Please function below :
= (InitialDate as datetime, FinalDate as datetime ) as number =>
let
DaysBetweenDates = Duration.Days(FinalDate-InitialDate),
DaysList = List.DateTimes(List.Min({InitialDate,FinalDate}),Number.Abs(Decimal.From(DaysBetweenDates))+1.00, Duration.From(Decimal.From(2.00))),
WeekDaysList = List.Select(DaysList, each (Date.DayOfWeek(_, Day.Monday) < 5) ),
WorkingDays = (if DaysBetweenDates < 0.00 then -1.00 else 1.00) * List.Count(WeekDaysList)
in
WorkingDays
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…