Forum Discussion

amit_saroha's avatar
amit_saroha
New Contributor III
4 years ago

Multiple Date Format Change

Hi There, I have multiple mappers with multiple date columns in YYYY-MM-DD format, within each mapper which I have to convert into the Oracle database data format. As of now, I am using expressio...
viktor_n's avatar
viktor_n
Contributor II
4 years ago

Hi @amit.saroha,

You can write your custom functions inside the expression file.
With this you will replace all those repeated expressions to reference to the of the expression file, and in feature if you choose to change the format of that dates, you would need only to update the expression file with the new date format.

Here is an example of how you can do that.
Expression File:

{
   formatDate: (date) => Date.parse(date).toLocaleDateTimeString({format: "YYYY-MM-DD"})
}

functions from expression file you can call them like this:

lib.ExpressionFileName.formatDate($date)

Regards,
Viktor