updating date automatically

[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

 

[Guest]

LEFT$(<your function>,3)

-Dorian

 

[Wakajeje]

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!

 

[Wakajeje]

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!