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.