updating date automatically

  • Thread starter Thread starter lilbit27
  • Start date Start date
L

lilbit27

=MonthName(Month(DateAdd("m",-1,Date()))) & " " &
Year(DateAdd("m",-1,Date()))

is there a way to make this say feb 2006 instead of february 2006
 
Hi lilbit27,

This is quite easy if you don't mind creating another expression to
package your final requirement. Supposing your first result's output
name is "First", a formula like:

= Left([First],3) & " " & Right([First],4)
or
= Left([First],3) & Right([First],5)

will solve your promblem. Cheers!
 
Hi lilbit27,

This is quite easy if you don't mind creating another expression to
package your final requirement. Supposing your first result's output
name is "First", a formula like:

= Left([First],3) & " " & Right([First],4)
or
= Left([First],3) & Right([First],5)

will solve your problem. Cheers!
 
Back
Top