Spelling out dates

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

If I have a field that is called "txtperioddate" that is a date field
formatted as dd/mm/yyyy how can I create a text field called
"txtperiodlabel" that spells out the month and year for example if
txtperioddate is 02/10/2004 I want it to create the value of txtperiodlabel
as October 2004
Thanks
Tony
 
=Format(txtperioddate, "mmm d")

If I have a field that is called "txtperioddate" that is a date field
formatted as dd/mm/yyyy how can I create a text field called
"txtperiodlabel" that spells out the month and year for example if
txtperioddate is 02/10/2004 I want it to create the value of txtperiodlabel
as October 2004
Thanks
Tony
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Tony,

Try setting the control source of the text box 'txtperiodlabel' to:
=format(txtperioddate,"mmmm yyyy").

I think that should do it.

Ian King
 
Back
Top