EOMonth to Query language

[lsgKelly]

Hi all...I need to convert an EOMONTH statement into an Access Query. The
current formula looks like this:

=EOMONTH(B16,(-1))

B16 now = ProposedEffDate

Is there a function in Access that will do this for me?

Thanks

Kelly

 

[Michel Walsh]

DateSerial( YearYouWant, MonthYourWant + 1, 0 )


returns the last of the desired month (and year):


DateSerial( 2008, 3, 0 )


for the last of February 2008, as example. You can see it as one day less
the first of March 2008: DateSerial( 2008, 3, 1) -1, or DateSerial( 2008,
3, 1 - 1).


Vanderghast, Access MVP

 

[fredg]

Hi all...I need to convert an EOMONTH statement into an Access Query. The
current formula looks like this:

=EOMONTH(B16,(-1))

B16 now = ProposedEffDate

Is there a function in Access that will do this for me?

Thanks

Kelly

In Access the last day of any month is the 0 day of the following
month.

=DateSerial(Year([DateField]),Month([DateField])+1,0)