Confusion with InQuarter function

[#1]

Hi,

I am trying to using the InQuarter function to detect a date which is in the previous quarter. So using a basedate of 12/31/2009 I would like to recognise 09/30/2009 as date in the previous quarter. Using the formula below, this is not happening. Would anyone know why this is the case?

Thanks for your help

=InQuarter('2009-12-31','2009-09-30',-1)

[vgutkovsky · Accepted solution]

Just reverse your dates: =InQuarter('2009-09-30','2009-12-31',-1)

Regards,

[#3]

Thanks Vlad. It looks I misunderstood the function.