Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on May 13, 2020

RELATED IDEAS

Spotfire Analyst - Native conversion function for date in ISO 8601 format

There is no current built in function to convert a string containing a date in ISO 8601 format.

Could TIBCO create this conversion function? This would avoid using substrings and DateTime.

Thank you for your consideration.

  • Attach files
  • Guest
    Reply
    |     Feb 5, 2022

    Hi Xavier,

    we have a custom extension implemented that allows you to convert strings based on the defined format into a date or vice versa (converting date into a string based on format) e.g.:

    ConvertDateToString(DateTime(2021,4,29,0,0,0,0), "dd.MM.yyyy")

    ConvertDateToString(DateTime(2021,4,29,10,20,30,0), "yyyy-MM-dd HH:mm:ss")

    or

    ConvertStringToDate("30-12-2021","dd-MM-yyyy")

    ConvertStringToDate("30.12.2021 10:25:18","dd.MM.yyyy HH:mm:ss")


    If that would help, let me know via michal.jakubik@miasolutions.sk

    Thanks,

    Michal

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