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.

     

Gabriel_Walkman's avatar
Gabriel_Walkman
Icon for Continued Contributor rankContinued Contributor
5 years ago

Hi!

 

The first row mentions variables "EndDate" and "StartDate", but they are not defined anywhere. Where / how did the trainer define them?