Jump to content

@MON inserts the two digit month—how can I best remove the leading 0?


Recommended Posts

Hi all.  The `@MON` macro inserts the two-digit current month.  But what is the best way to insert the one-or-two-digit month?  In other words, if the current month is May, I'd like to insert `5` instead of `05.  Would I just have to manually insert an `IF()` statement to check if a leading zero is present, and remove it if so?  Just wondering if there are more established/automated/built-in methods of doing so.

 I'm also interested in doing the same for the day macro (`@MDAY`).

 Thanks in advance.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...