T torquay Registered User. Local time Today, 19:13 Joined Dec 27, 2005 Messages 85 Oct 27, 2009 #1 Hi I am trying to display last month by name in a field. I can display this month with =Format(Now(),"mmmm") but I can't seem to get it to show last month even with -1 Any ideas Thanks Kim
Hi I am trying to display last month by name in a field. I can display this month with =Format(Now(),"mmmm") but I can't seem to get it to show last month even with -1 Any ideas Thanks Kim
DCrake Remembered Local time Today, 19:13 Joined Jun 8, 2005 Messages 8,620 Oct 27, 2009 #2 format(DateAdd("m",-1,Date()),"mmmm") Will do the trick David
T torquay Registered User. Local time Today, 19:13 Joined Dec 27, 2005 Messages 85 Oct 27, 2009 #3 Thankyou for a fast reply