Start of month

[IanT]

Hi

This is probally really easy........

I have data with dates like 15/05/2005, 30/09/2005.

I need to convert the dates to 01/05/2005 and 01/09/2005

Can anyone help!

 

[Murli]

You can use an update query to change the dates.

 

[ScottGem]

=DateSerial(Year([datefield]),Month([Datefield]),1)

Will return a date of the first of the month listed in the datefield.