Determining the current month

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

  • Author
    Posts
    • #247
       Frank
      Keymaster
      • 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.

CONTACT US

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

Sending

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

Log in with your credentials

or    

Forgot your details?