AnsweredAssumed Answered

trim result set of an executesql in calculation for a chart.

Question asked by kawaii on Mar 22, 2018
Latest reply on Mar 27, 2018 by erolst


hi. i have a chart where i populate one of my axis with some dates.

i have result set of

2017-07-12

2018-03-01

2018-03-14

 

how do i loop through this and trim it so it will display

 

2017-07

2018-03

2018-03

Outcomes