title: change date format m/d/yyyy to dd/mm/yyyy using formula
body: <pre><code>  sr  date       date-text  mm  dd  yyyy    concat(dd,mm,yyyy)
    1   12/31/2018 12/31/2018 12  31  2018    31/12/2018
    2   3/31/2019  3/31/2019  3/  1/  2019    1//3//2019
  </code></pre>
  
  <p>as shown above i have some dates in col 'date' formatted as m/d/yyyy. i need to convert this to dd/mm/yyyy. i tried DATEVALUE funtion but it gives value error as my pc date format is dd/mm/yyyy. Unfortunately i cant change my PC date format.
  So i tried to split the date using LEFT,MID and RIGHT function.</p>
  
  <pre><code>date-text = TEXT([@[date]],"mmm/ddd/yyyy") - to fix date format to mm/dd/yyyy
  mm =LEFT([@[date-text]],2)
  dd =MID([@[date-text]],4,2)
  yyyy=RIGHT([@[date-text]],4)
  concat(dd,mm,yyyy) = =CONCAT([@dd],"/",[@mm],"/",[@yyyy]) to get mm/dd/yyyy for mat.
  </code></pre>
  
  <p>This approach works for row 1 but for row 2 i get wrong date "1//3//2019". please let me know how to fix this</p>