Close popover
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

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