Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Rolling12 months query

Hi,

I've tried many times to create a list of the latest 12 complete months but failed, essentially I would like a funciton like

List.Dates with syntax List.Dates(start as date, count as number, step as duration) but the duration can only be days, not months thus making it difficult for me. I would like todays date minus 10 days to be my starting month or ideally "YYYYMM" and then the following to be the 11 months before that. Any ideas? Thank you!

No Replies