Set analysis

[jjking58]

I've been trying to figure this out and have been unsuccessful. Hopefully someone can help

The following date range is not working and I'm not sure why. 

sum({1<AcctPeriod={">=$(=fStartYear)<=$(=EndMonth)"}>}Amount)

Set vFM2 = 10 ;

Date(Date#(fYear & $(vFM)-3,'YYYYMM'),'YYYYMM') as fStartYear, 

Date(Date#(Year + If(Month<$(vFM2), 1, 0)& num(Month,'#00'),'YYYYMM'),'YYYYMM')as EndMonth,

Date(Date#(AcctPeriod,'YYYYMM'),'YYYYMM') as  AcctPeriod,

Thanks in advance

[vishsaggi]

Are the figures wrong or you getting any error? Can you share a sample file to look into? Also tell us your expected output?

[kfoudhaily]

what about date formats?

possible to share data sample?