Calculating first day of a month for a date field

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,
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup 7
Last day of month in query 15
Previous Month Date Function 5
Access 2007 Date field shows Now instead of Date 4
Datepicker issue after changing Windows' short date time format 5
Using DateAdd and IIF conditions in a Query 2
Time Left 4
Period End Dates Table ... How to Link? 3

Top