Determining the current month

This topic has 0 replies, 1 voice, and was last updated 6 years, 10 months ago by Frank.

  • Author
    • #247
      • Topics Started - 80
      • Replies Written - 53

      We got the following question from a Stratum user –

      “Is there a way to use a “Date Based” value in a calculated measure.

      For example, “This Month” = July = 07,

      Can I create a calculation that uses the numeric value of “This Month” (7) as part of the calculation?”

      To get the current month in a calc you can use the datepart function. Datepart(“m”,now()). You can also use w for week number and I think d for day.

Viewing 0 reply threads

You must be logged in to reply to this topic.


We're not around right now. But you can send us an email and we'll get back to you, asap.


©2022 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials


Forgot your details?