[AccessD] Format date in a text box

Tesiny, Ed EdTesiny at oasas.state.ny.us
Thu Jun 10 09:18:13 CDT 2004


Try
=Format(Date(),"mmmm") 


Ed Tesiny
EdTesiny at oasas.state.ny.us

-----Original Message-----
From: Kaup, Chester A [mailto:kaupca at chevrontexaco.com] 
Sent: Thursday, June 10, 2004 10:03 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Format date in a text box

I am trying to display the full month name in a text box on a report. I
tried the following but get January1. What should the format statement
look like? Thanks
=Format(Month(Date()),"mmmmm")

Chester Kaup
Information Management Technician
IT-MidContinent/MidContinent Business Unit
CTN 8-687-7415  
Outside 432-687-7414

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced. 



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list