Hi

on sage 100 standard 2017

I am trying to pull 2 years with of data from our AR_InvoiceHistoryHeader/Detail records.

The report i am trying to write will compare 2 years worth of data.  so if I put in a date like May 31, 2018 it will compare may 2018/may 2017, april 2018/2917, march2018/2017 etc 12 months comparison to the previous years data.

I have buckets building my data, and the first 5 months work perfectly  may,april,march,feb, jan work comparing both years, when it gets to dec 2017 it pulls that data but for some reason it will not pull dec 2016 data. 

I have tried putting in no record select criteria in the report so it goes thru the entire file but it still will not pull.  i have written a report for dec 2016 and have data populating from that table so i know i have data.

i have tried using datediff("m",{AR_InvoiceHistoryHeader.InvoiceDate},{?PromptFromDAte}) in 0 to 23  and that also only pulls the first 5 months comparison and only the 6month not the comparison month to this one. the comparison month doesnt pull any data.

does anyone have any thought on what i am doing incorrectly?