Generate 1 record for each of the previous 12 months

[ddiesel]

We need to generate records for each of the preceding 12 months. We are using a Generate Rows tool, Formula tool, and Multi-Row Formula tool but we can't get the dates just right. I think it may be due to the the number of days per month.

Can you help us fix the attached workflow? Or suggest a better method?

R	Q	C	Date Suspected
ABC	1204101	1	3/1/2018
ABC	1204101	1	1/1/2018
ABC	1204101	1	12/1/2017
ABC	1204101	1	11/1/2017
ABC	1204101	1	10/1/2017
ABC	1204101	1	9/1/2017
ABC	1204101	1	8/1/2017
ABC	1204101	1	7/1/2017
ABC	1204101	1	6/1/2017
ABC	1204101	1	5/1/2017
ABC	1204101	1	4/1/2017
ABC	1204101	1	3/1/2017
ABC	1327401	1	3/1/2018
ABC	1327401	1	1/1/2018

Thank you!

Tagging: @mocalvo

[BenMoss · Accepted solution]

I see what you are trying to do here.

The simplest solution would be to use the datetime functions within the generate rows tool it's self.

Check out this solution.

Ben

[ddiesel]

I did not know you could use DateTime functions in the Generate Rows tool. So cool!

Thank you @BenMoss