11 Replies Latest reply on Feb 6, 2015 7:26 AM by madmike6537

    Format date field in delimited data chart

    madmike6537

      Hi All,

       

      I have a chart that I am using delimited data to populate using the Execute SQL function. The problem I have is the date is always formatted as: yyyy-mm-dd

       

      I would like it to be dd-mm-yyyy

       

      I cant seem to change it though. There is a built in dropdown in the chart that allows me to change it to "date" but when I do, my data turns into question marks. "?"

       

      The field I am pulling data from via executeSQL is a date field. Should I try to convert it into a date again in the calculation or something? The calculation says the data returned must be "text".

       

      Here is the SQL statement:

       

      ExecuteSQL ( "SELECT DISTINCT Reading_Date FROM MATERIAL_READING WHERE \"_Room_KF\" = ? ORDER BY Reading_Date"; ""; ""; level_ROOM::_Room_PK)

       

      Thanks in advance.