Forum Discussion

EmilyM2019's avatar
EmilyM2019
Helper II
6 years ago

Working days date count

Good morning,   I am working on a report where I need to track the number of working days from the point an activity started.    I did some Googling and watched a YouTube video and came up with a...
Need Help
EmilyM2019's avatar
EmilyM2019
Helper II
6 years ago

Hi Jimmy801 ,

 

Thanks for coming back to me. I'm so new at this and I don't really understand your response. Sorry.

 

I know from other posts that I the syntax that I need for the today M query is (DateTime.LocalNow() 

 

But for me that is still erroring.

 

This is what I have changed my code to:

 

= Table.AddColumn(#"Changed Type1", "Working days count", each #"Working days query"([#"Changed On (Task)"], DateTime.FixedLocalNow()))

 

But I can't understand why this isn't working.

 

Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello EmilyM2019 

 

first of all please copy my first code to a new blank query and name the query fnNetWorkDays2

 

then change your code as follows

= Table.AddColumn(#"Changed Type1", "Working days count", each fnNetWorkDays2([#"Changed On (Task)"], DateTime.FixedLocalNow()))


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

  • EmilyM2019's avatar
    EmilyM2019
    Helper II
    6 years ago

    Hi Jimmy801 

     

    When I copy and paste your code into a new blank query it doesn't load in as an fx query, it shows as ABC and all the text is in red.

     

    What am I doing wrong?

     

    Thanks, Emily.

     
     
    • Jimmy801's avatar
      Jimmy801
      Community Champion
      6 years ago

      Hello EmilyM2019 

       

      most probably you are copying into the formula bar. 

      Open the advanced editor, delete everything and paste my first code

       

       

      If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
      Kudoes are nice too

      Have fun

      Jimmy