Format Date to 1st day of month

[Guest]

Help Please!!!

I am trying to format a date within Access Design Viewer.

My field name is [Flight_Date], this field contains each day of the year.
What I want is to format it so that it returns the first day of each month
(this will help me group easier)

For instance: if the value of Flgiht_Date was 1/25/2006 it would return
1/1/2006.

I tried using Format(DateValue([Flight_Date]),"mmmm") but that just gives me
the month name.

Any ideas?

 

[Guest]

dateserial(year([Flight_Date),Month(Flight_Date),1)