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
    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

    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 LLC. All rights reserved. This page and your use is governed by these Terms of Use.