B BrianFawcett Registered User. Local time Today, 11:24 Joined May 3, 2010 Messages 63 Apr 12, 2011 #1 I am creating a report and I want the title to be "Sales Adjustments CURRENT MONTH". Is there a way to this easliy?
I am creating a report and I want the title to be "Sales Adjustments CURRENT MONTH". Is there a way to this easliy?
pbaldy Wino Moderator Staff member Local time Today, 11:24 Joined Aug 30, 2003 Messages 36,157 Apr 12, 2011 #2 Presumably you mean with the actual month displayed? Try a textbox: ="Sales Adjustments " & Format(Date(), "mmmm")
Presumably you mean with the actual month displayed? Try a textbox: ="Sales Adjustments " & Format(Date(), "mmmm")
B BrianFawcett Registered User. Local time Today, 11:24 Joined May 3, 2010 Messages 63 Apr 12, 2011 #3 Can I add year by adding "yyyy" to the textbox?
pbaldy Wino Moderator Staff member Local time Today, 11:24 Joined Aug 30, 2003 Messages 36,157 Apr 12, 2011 #4 Look in help at the Format() function. You can customize it pretty much any way you want, or you can concatenate the year on separately.
Look in help at the Format() function. You can customize it pretty much any way you want, or you can concatenate the year on separately.