HDL formula

Summary

Transformation of Date

Content

Team,

We created HDL type FF and we have a challenge like we are not able to convert the date format . The raw file has the date in yyyy-mm-dd format and we want our FF to convert that into yyyy/mm/dd as this is the format accepted by HDL. Any help and suggestions on how to achieve this ? The DateFrom and DateTo needs format change to "yyyy/mm/dd".

Any help would be much appreciated . Tried both to_char and to_date as well and that does not help. 

FF below:-                                                                                                                                                   *

* FORMULA NAME: GENERATE_EMAIL_HDL_FROM_Text