I have checked the archives and did not find an answer to formatting SQL dates (more than one date returned) from YYYY/MM/DD to MM/DD/YY format. Here is my SQL statment which lies in a ToolTip calculation:
~SQL = "SELECT DISTINCT dateCreated
WHERE id_Course = ?";
ExecuteSQL ( ~SQL; ""; "¶"; Course via Dashboard id_Program::id)
And here is what is being returned:
There will usually be more than 2 rows returned so I can't use the Substitute (SQLResult; "-"; ¶) since the result will be more than one date. I hope there is an easy solution.