Trying to figure out the error

[Brash1]

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

[Brash1]

Thanks Pete, I think this solution worked.

[BA_Pete]

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

Pete

[BA_Pete · Accepted solution]

Hi @Brash1 ,

Try something like this:

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

Pete