Calculate absence days with no end date

[Casi]

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 no end date yet.

Days ={Number.From([Absence.Start])..Number.From([Absence.End])}

I am wondering if it possible to amend this query so that if there is no end date it will use todays date? Any assistance would be greatly appreciated.

[Casi]

Perfect. Thank you

[Vijay_A_Verma · Accepted solution]

Use this

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