AnsweredAssumed Answered

Format date field in delimited data chart

Question asked by madmike6537 on Feb 5, 2015
Latest reply on Feb 6, 2015 by 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.

Outcomes