How to change the date format from YYYY-MM-DD to MM/DD/YYYY and add text before date

[skasira59-16573]

I want to write a dimension with adding text values and date with MM/DD/YYYY format
eg: Result for: 2022/11/05

  dimension: resultfor {
    type: string
    sql:  'Result For : ' || ${admin_dt_date} ;;
    html:{{ rendered_value | date: "%m/%d/%Y" }};;
  }

Result is showing with the above dimenstion is like 
“Result For : 2022-11-05” But I Need “Result For : 11/05/2022”

[skasira59-16573 · Accepted solution]

This is working fine

dimension: result_for_date {    
type: string    
sql: 'Result For:' || to_char(${admin_dt_date}, 'MM/DD/YYYY') ;;  
}