Calculating first day of a month for a date field

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

I have a date field called RNDate with a long date format (i.e. 07/15/2007
9:29:00 AM). I want a separate field Called StartMonth which would be the
first day of the month from the RNDate field. So the value would be
07/01/2007 for this example. Can someone help?
Thanks,
 
Chuck

Take a look at the DateSerial() function in Access HELP for exact syntax --
it will look something like (untested):

DateSerial(Year([RNDate]), Month([RNDate]), 1)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top