Forum Discussion
tiagocarvalhal
3 years agoFrequent Visitor
Help with List.Generate between two dates
Hi everyone, I´m trying to get a list of months between two dates using List.Generate. When I try compare a column with a specific date like today, it´s is working perfect. The problem is when I ...
- 3 years ago
Hi, use the custom column
{Number.From([Start Date])..Number.From([Exit Date]) }
then expand the list .This article of mine describes nicely how to generate those dates
https://www.linkedin.com/pulse/hr-reporting-generating-records-between-start-end-values-dontsova/?trackingId=MpZxmQguRYuOR%2BXY8OmiLA%3D%3D
olgad
3 years agoResident Rockstar
Hi, use the custom column
{Number.From([Start Date])..Number.From([Exit Date]) }
then expand the list .
This article of mine describes nicely how to generate those dates
https://www.linkedin.com/pulse/hr-reporting-generating-records-between-start-end-values-dontsova/?trackingId=MpZxmQguRYuOR%2BXY8OmiLA%3D%3D