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

Format(Date)

variable = Format(Date, mmm). for example gives you Sep
how do I receive the previous month Aug. I have tried:
variable = Format(Date, mmm)- 1, but I get a Type Mismatch
error.
Thank You
0
robhas
Asked:
robhas
1 Solution
 
mcixCommented:
variable = Format$(DateAdd("M", -1, Now), "mmm")
0
 
robhasAuthor Commented:
Worked Great
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