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

    Format date field in delimited data chart


      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.