Keep date formatting intact while using read csv activity

Help Forum
, , ,
1

Hello. I want to read a csv and write it to an excel without changing any format, but the date format gets changed i.e. if the date is 02-04-2022 it is converted to 04-02-22, so that i get wrong date along with wrong month. Please help in this regard

2

Hey @Tusharkanta_Panda

You can use BalaReva CSV Activity available in the marketplace which converts CSV to Excel file by specifying the column format. Find the below link & hope this helps.

Regards,
Arjun

3

Hi @arjunshenoy
Thanks for the suggestion. But I couldn’t import this activity package after downloading as it does not appear on studio local packages. I tried adding package source also placed the ‘nupkg’ file inside studio\packages folder, still no result and this activity isn’t even available inapp marketplace.