Changing a date to start of next month

  • Thread starter Thread starter David Gartrell
  • Start date Start date
D

David Gartrell

Hi there,

I wonder if someone can tell me how I can change a date in a table so that
is shows the 1st day of the following month. E.g. today is July 3rd and i'd
like to change the value in the table to show 1st of August. It would need
to work the same for every month of the year. I think i need to use the
'datepart' function but not sure how to.


Many thanks for your help

David
 
For a given date MyDate, the first of the next month will be
DateSerial(Year(MyDate), Month(MyDate) + 1, 1)

Not quite sure what you're trying to do with this value, so I can't give you
any more specific advice on how to use it.
 
Back
Top