dateserial to month(as string)

[JMorrell]

I have a need to write out the word "August" or "September" or any other
month based on a dateserial value of the previous month.

Is there a function to do this or do I have to write the code. I don't mind
doing that, but if there is a function, I would rather us it.

tia

 

[Dirk Goldgar]

I have a need to write out the word "August" or "September" or any
other month based on a dateserial value of the previous month.

Is there a function to do this or do I have to write the code. I
don't mind doing that, but if there is a function, I would rather us
it.

You can use the Format function to convert a date value to a month name:

Format([Your Date Value or Expression], "mmmm")

 

[Ken Snell [MVP]]

Or this works too:

MonthName(Month([YourDateValue]))

--

Ken Snell
<MS ACCESS MVP>

I have a need to write out the word "August" or "September" or any
other month based on a dateserial value of the previous month.

Is there a function to do this or do I have to write the code. I
don't mind doing that, but if there is a function, I would rather us
it.

You can use the Format function to convert a date value to a month name:

Format([Your Date Value or Expression], "mmmm")

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[JMorrell]

Thanks for the info.
--
JMorrell

I have a need to write out the word "August" or "September" or any
other month based on a dateserial value of the previous month.

Is there a function to do this or do I have to write the code. I
don't mind doing that, but if there is a function, I would rather us
it.

You can use the Format function to convert a date value to a month name:

Format([Your Date Value or Expression], "mmmm")

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)