Spotfire Ideas Portal
Add a new idea Subscribe
Status Already exists
Product Spotfire Statistica
Created by Guest
Created on Sep 18, 2017

RELATED IDEAS

Function to extract Month in Text format from Date Field

Hello Team,

 

The current DTMonth function will return month from Date field in 2 digit number format. I need to write 12 conditions to get the respective text of month. Ex: If month=01 Then Month='January'.
Instead I am looking to see if we can have a function that extract the name of the month directly.

Best,
Sai Krishna

  • Attach files
  • Guest
    Oct 25, 2017

    =tostringex(v1,'mmmm') should already work.

    Reply
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved