Return the date of the 1st day of the month from a date in the month

D

Dave Gibson

Hi,

I wish to obtain the date of the 1st day of the month for any number
of dates within the same month.

For example 23/12/2005 would return 01/12/2005 in dd/mm/yyyy format

I used to know how to do this but cannet get it right now. I am sure
it is with the dateserial function and some arguments etc.

Many thanks
 
F

fredg

Hi,

I wish to obtain the date of the 1st day of the month for any number
of dates within the same month.

For example 23/12/2005 would return 01/12/2005 in dd/mm/yyyy format

I used to know how to do this but cannet get it right now. I am sure
it is with the dateserial function and some arguments etc.

Many thanks
Click to expand...

Format(DateSerial(Year([DateField]),Month([DateField]),1),"dd/mm/yyyy")
 

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

Excel Message box with days of month & date. 1
Change a datefield to the first day in the given month? 5
1st of The Month 2
Days in part of the month 1
Convert mid month date to month end date 3
date function 3
Access Count dates within a Month 4
Date - Beginning of Month 1

Top