Forum Discussion

Brash1's avatar
Brash1
Frequent Visitor
1 year ago
Solved

Trying to figure out the error

Hello,  Trying to figure out this error   Trying to figure out days between current date and request date for items that do not have a finish date, getting an expression error We cannot apply fiel...
Need Help
  • BA_Pete's avatar
    BA_Pete
    1 year ago

    Hi Brash1 ,

     

    Try something like this:

    if [#"Finish Date #(lf)"] = null
then Duration.Days(Date.From(DateTime.LocalNow()) - [Request Date])
else 0

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
1 year ago

Hi Brash1 ,

 

Try something like this:

if [#"Finish Date #(lf)"] = null
then Duration.Days(Date.From(DateTime.LocalNow()) - [Request Date])
else 0

 

Pete