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
      Drop here to upload
    • Guest
      Reply
      |       Oct 25, 2017

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

    This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us