IF Day element is not 01 then change to 01

[ali32uk]

HI

I have an update query which has 5m lines, one of the columns is a date column, what I d like to do is change the day part of the date to be 01.

for example

Current Afterupdate
26/12/2014 01/12/2014
27/10/2014 01/10/2014
18/02/2015 01/02/2015
27/10/2014 01/10/2014
07/11/2014 01/11/2014

I m not sure how to update a specific element of the date only and change all to show "01"

I would appreciate any help!

Alastair

 

[SkipVought]

Hi,

Why change your date to make it less granular?

Simply report first of month in your query. SIMPLE!

 

[SkipVought]

DateSerial(Year(Current),Month(Current),1)

 

[ali32uk]

Perfect thankyou, it just the way its needed for person its being outputted too