• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

format month

bearing in mind todays date:

CurrentMonth = Format(Month(Now), "mmm")

evaluates to jan I had hoped it would say Mar

Month now() says 3 which is correct

the format says different.

am in vba

0
PeterBaileyUk
Asked:
PeterBaileyUk
1 Solution
 
Rey Obrero (Capricorn1)Commented:
too much redundancy, just use

CurrentMonth = Format(Now(), "mmm")
0
 
PeterBaileyUkAuthor Commented:
thank you!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now