Adding date records

[scubadiver007]

Hello,

How might it possible to automatically add the first of the month to a table using the computer date.

So 01/01/2014 would be added as a record on that date only and not for the remainder of the month, same for 01/02/2014 etc

BTW, these are DD/MM/YYYY formats

 

[AlexHedley]

So do you want whenever you add a record for the Date field to say the first of the current month?

How about using DateSerial?

Set the Default Value either in the Table or Form.

DateSerial(year, month, day)

http://office.microsoft.com/en-gb/access-help/dateserial-function-HA001228813.aspx

You could get the Year and Month of the given date and always set the Day as 1.

DateSerial(Year(Date()), Month(Date()), 1)