Changing Day to 15 without affecting Month or year in date field.

[nstouffer]

I have a date field "RecheckDate" in SQL. I need to update the Day to 15 for all rows.

05/31/02 will become 05/15/02
06/24/02 06/15/02
08/23/02 08/15/02

What is the best function to use to accomplish this?

I had trouble using the Day(Recheck) = 15 function in
an update query, can anyone help?

nstouffer

 

[AWithers]

what about

update yourtable
set RecheckDate = RecheckDate-day(RecheckDate)+15

Andy

 

[nstouffer]

Worked excellent!
Thank you so much!
nstouffer