Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date function No Longer working

My date function is no longer working. I obtained the following function from a Microsoft Trainer: let     DayCount = Duration.Days(Duration.From(EndDate - StartDate)) + 1,     Source = List.Dates...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    create the 2 parameters in PQ editor, set their type to Date

     

    result:

     

     

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.

     

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi Anonymous 

create the 2 parameters in PQ editor, set their type to Date

 

result:

 

 

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.