SummaryTransformation of Date
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