Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
HDL formula — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HDL formula

Accepted answer
20
Views
4
Comments
edited Aug 25, 2020 10:22AM in HCM Integrations 4 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!