Forum Discussion

Casi's avatar
Casi
Icon for Helper I rankHelper I
4 years ago
Solved

Calculate absence days with no end date

Hi,   I wonder if someone could help me with my query.    I am trying to calculate days of staff absence. I have created a query which works for the majority of absences apart from ones that have...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this

    = {Number.From([Absence.Start])..Number.From(if [Absence.End]=null or [Absence.End]="" then Date.From(DateTime.FixedLocalNow()) else [Absence.End])}

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use this

= {Number.From([Absence.Start])..Number.From(if [Absence.End]=null or [Absence.End]="" then Date.From(DateTime.FixedLocalNow()) else [Absence.End])}