In an excel how can we get Data in date and time format

Learning & Development Programs Automation Starter
1

Screenshot (150)
Screenshot (150)1920×1080 265 KB

In Provided screenshot From AR-AU column i need to get data in date and time format.

2

Hey!

Check the Preserve format in read range activity…

Then take one for each row in data table pass the read range output

take one assign activity and mention like this

Assign strCreated = CurrentRow("Created").ToString.Trim

Assign DateCreated = Datetime.ParseExact(strCreated.ToString, “MM-dd-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Change the format according to your excel format

Do the same for AU Column

If the mentioned expression not working in your case…

Send us the format here…

Regards,
NaNi

3

15-05-2022 10:16:04 AM

This is the Format

4

Hey!

Try this:

Assign DateCreated = Datetime.ParseExact(strCreated.ToString, “dd-MM-yyyy hh:mm:ss tt”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy hh:mm:ss tt”)

Note:

Datecreated is a DateTime Variable…

Regards,
NaNi

6

Hello @sandhyareddy

How you are getting this data? Is it from some table in application and you are writing to the excel? or are you downloading the excel file itself?

Also will it possible to share a sample excel here?