R. Parusharam Member since 2018 3 posts
Atos IT Solutions and Services GmbH
Posted: 1 year ago
Last activity: 1 year 9 months ago

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 Interface
Moderation Team has archived post
Share this page LinkedIn