Date field from Excel sheet to webpage Automation

Help
,
#1

I am trying to take DOB value from Excel sheet to Web page.
Using Type into Activity in the Text as .Tostring.
But on the Web page it is giving me some random number instead of date.
How to get the date value as is to Web page.

Thanks for the help in advance.

#2

Hi @Radhika_Lagadapati welcome to forum

Can u share the screenshot of how the date is coming as output?

#3

Hi @Radhika_Lagadapati,

A simple trick is to ensure that you check the property “PreserveFormat” when reading data from excel. (See yellow mark in the image below)
This way UiPath will read the string/number as is in the excel sheet without changing formats. This is very useful function of Read range and other read activities like Read PDF text etc.

image

Hope this helps!

#4

Thank you Jeevith it worked.

#5

Thanks Nived.
PreserveFormat option worked.

1 Like
#6

@Radhika_Lagadapati

Welcome to community

Regarding the number, you can check below for your reference
https://forum.uipath.com/t/tutorial-convert-number-to-date-format/249171/3

Hope this helps you

Thanks

#7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.