Parusharam Regati (R. Parusharam)
Atos IT Solutions and Services GmbH

Atos IT Solutions and Services GmbH
R. Parusharam Member since 2018 3 posts
Atos IT Solutions and Services GmbH
Posted: December 17, 2018
Last activity: December 18, 2018
Posted: 17 Dec 2018 3:57 EST
Last activity: 18 Dec 2018 15:31 EST

Date Convertion From Excel to DB


I have a Rrequirement to Upload an Excel which i have to add two date fields in Excel. I have created Property type as text in pega and Column is a Date type in DB.

Now When i am adding a date in Excel it is Converting into Some Integer Value on Clipboard. Now i have to Convert that Integer whatever into Date Format and I have to Save the Data Into DB.

Ex: In Excel Column DATA Validity = 22-12-2018

it's converting as "45655" on to Clipboard.

Now This 45655 Value I have to Convert as 22-12-2018.

How can we Achieve this?

Note: I am Using OOTB Activity MSOParseExcel to read the Excel Data.

***Edited by Moderator: Pallavi to update platform capability tags***

Data Integration Java and Activities User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.