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

  • Thread starter Thread starter Dave Gibson
  • Start date Start date
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
 
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")
 
Back
Top