map date format data to target table with particular format

[Gillerla Rajesh]

Hi There,

in excel sheet we have different type of date format data. now i need to load data to target table . in target i need to follow particular format like yyyy-mm-dd , how should  i achive this.

can one proivde transfrom script for this.

Regards,

Rajesh.

[Animesh Das2]

Hi @Gillerla Rajesh ,

You can simply create the field mapping in the transform map and mention the 'date format' your want. PFB SS (with highlighted the field in yellow) as a sample one for reference.

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

You can accept multiple responses from different community members as well.

Thanks, 

Animesh Das

[Animesh Das2]

Hi @Gillerla Rajesh,

If you got chance to check the suggestion/solution and if this addressed your question, please mark this response correct by clicking on Accept as Solution and/or Kudos so that it may be helpful for others as well in the community.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das