Form date field showing the start of the previous Quarter

[PWD]

Good morning, I have inherited an Access database that has a form containing a field that has to show the start date of the previous quarter - in this case that would be 1st October 2014. I was trying to understand the Default Value text as it came up showing 2nd October. I amended it as below and it now shows "01/10/2014", so I'm pretty happy about that, but I'd really like to understand what's going on if anyone could spare the time to explain.

=DateAdd("m",-3,(DateSerial(Year(Date()),3*Int(((Month(Date()))-1)/3)+1,1)-1))+1

Many thanks,
D€$

 

[PHV]

Doesn't this simpler formula suffice ?
=DateAdd("m",-3,DateSerial(Year(Date()),3*Int(((Month(Date()))-1)/3)+1,1))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWD]

Hi, yes that worked perfectly well.

This also appears to do the job

=DateAdd("m",-3,DateSerial(Year(Date()),Int(Month(Date()))-1,1))

I can't really see the point of multiplying and dividing the 'Int' result either.

Many thanks,
D€$