CONCAT(SUBSTR(endDate,6,4),"-",SUBSTR(endDate,0,2),"-", SUBSTR(endDate,3,2),"T",SUBSTR(endDate,11))
checkout Compare date data in string ("MM/dd/yyyy") with between clause
CONCAT(SUBSTR(endDate,6,4),"-",SUBSTR(endDate,0,2),"-", SUBSTR(endDate,3,2),"T",SUBSTR(endDate,11))
checkout Compare date data in string ("MM/dd/yyyy") with between clause