Update Query not returning correct date information...for dates starting 3/1/xxxx 1

[puforee]

I am using an update query in MS Access 2010.

Field: PC Due
Table: table_Training_Dates
Update to: DateAdd("m",1,DateSerial(Year([Base Month]),Month([Base Month]),1)-1)
My Base Month date is 3/1/1015 The update to PC Due shows 3/28/2015. It should show 3/31/2015

I run this on many different Base Month dates (All are the first of the selected month) and the PC Due dates all come out correct. Same month...but the last day of the month.

2010 does not have the EOMonth Function.

Can anyone help.

 

[SkipVought]

hi,

End of Month: DateSerial(Year([Base Month]),Month([Base Month])+1,0)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[puforee]

SkipVought...that did the trick..thanks.

I may be back with come conditional formatting issues...look for more if I run into trouble.