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 field access to the type Function.
Details:
Value=[Function]
Key=Current Date

 

This is my current expression

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

 

Thanks in Advance

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

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Super 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

  • Brash1's avatar
    Brash1
    Frequent Visitor
    1 year ago

    Thanks Pete, I think this solution worked.

    • BA_Pete's avatar
      BA_Pete
      Super User
      1 year ago

       

      Brilliant! Glad that's worked for you.
      Don't forget to give a thumbs-up on any posts that have helped you 👍

       

      Pete