Forum Discussion
Solved
Help - List.Generate dates with variable frequency in months
Hi, I'm trying to generate a list of jobs to do in the next 2 years I have a working custom column that provides me the list of dates. But my jobs have varying frequencies of 2-12 months intervals...
It might be a field access error.
Try
let freq = [FREQUENCY] in each Date.AddMonths( _ , freq))
It might be a field access error.
Try
let freq = [FREQUENCY] in each Date.AddMonths( _ , freq))
It generates without issue once i added in this line
Thanks!Hi ben-t,
Could you share the full code that worked for you?
I think I've tried every possible code with the above solution, but I still get an error.
Thanks!
Hi GekkeHellie
this is the code i used
let freq = [FREQUENCY] in
List.Generate(
() => [Next job],
each Date.From(_) <= Date.From(Date.AddYears(Date.EndOfYear(DateTime.LocalNow()),1)),
each Date.AddMonths(_, freq))
