mark_b

Formating SQL Dates to US format

Discussion created by mark_b on Jun 5, 2014
Latest reply on Jun 17, 2014 by gdurniak

Hi All,

 

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:

 

Let (

~SQL = "SELECT DISTINCT dateCreated

FROM CoursesChanged

WHERE id_Course = ?";

 

ExecuteSQL ( ~SQL; ""; "¶"; Course via Dashboard id_Program::id)

)

 

And here is what is being returned:

2014-06-02

2014-06-04

 

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.

 

Cheers, Mark

Outcomes