Returning the first of the month for every date in that month

[Guest]

I have a caculated field that contains dates, I would like to have those
dates show up as the first of the month (for example if it's 12 Aug 05; I
would like for the result to be 1 Aug) Any assistance would be greatly
appreciated.

 

[SteveS]

I have a caculated field that contains dates, I would like to have those
dates show up as the first of the month (for example if it's 12 Aug 05; I
would like for the result to be 1 Aug) Any assistance would be greatly
appreciated.

The "Access Web" site has several date functions including "FirstOfMonth()".
See:

http://mvps.org/access/datetime/date0007.htm

HTH

 

[Van T. Dinh]

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

should do.