How to get Dates and Times from Excel in the right format with UiPath - Full Tutorial

This video tutorial shows, how to get Excel Dates and Times in the right format with UiPath. If you don't do nothing, it will be in the DateTime.ToString format. It's shown, how we convert the dates and times to the exact format, we want.

00:00:26 How to get the Date from Excel
00:07:01 How to get the Time from Excel
00:10:26 How to get the Date and Time from Excel

🔔Subscribe if you enjoyed

🤖UiPath Tutorial

#uipath #rpa #tutorial

[henrikn]

Once again Anders to the rescue! 🙂
Been dealing with this issue all day, and of course Anders has a great video to show how its done! Thanks!

[Idontknow]

You Sir, are a God sent HUGE THANKS FOR SAVING MY DAY

[aleksandrpantsesnyi]

Thank you very much !!! I tried to find how to do this and you explained it. Your tutorial is AWESOME !!!

[anuv]

Thank you so much for such a wonderful video

[Snipaa]

Hello, what would be the correct course of action if when I use write line it only outputs the last date in the excel sheet

[fouried]

Hi, could you do a video on the opposite, where you want to write your DT to excel and have the format stay the same as it is in UiPath Studio

[radenbayuherlambang]

how to input datetime from excel to from web divided into 3 input fields, for example
from excel with format (DD-M-YYYY) to web format into DD, M, YY (Field by field) (into each field) ?

[anandkumar-hcfw]

hi Anders, i have 14 records(Rows) in excel to change Date format, its working fine changing Date Format, but after 14 records execution it showing error like -> "message": "Format Value: Object reference not set to an instance of an object.", why it showing errror After Execution of last record. ????

[aakashpoly]

Hi Anders,

I have followed the steps you have mentioned in the video and below is the error I am getting :



Source: Format Value

Message: Cannot convert Generic Value to System.DateTime

Exception Type:

Data I was trying to convert is : "2/28/2021 12:00:00 AM"
Format I have selected : MM/dd/yyyy

[ashwinswain]

Hello Anders can you please tell me how to extract excel cell data based on todays date..u can imagine it as a roster from 1 to 31 in 1st row...n different services in 1st column..say today is 1 so it will assign services variable to the resources on 1 n so on for 2 to 31.. please help🙏🙏

[neek]

Can you read dob from excel and calculate the age then display age in the same excel file

[plasaferstone]

Hi Anders! i have an error in this application. "Cannot Convert Generic Value into System.Date.Time"

[mscoder]

Thanks, how I can wrote data in excel?

[mikeadams]

This is an excellent video just like all of the others that you present. This works well for date columns that have been custom formated in excell but some client spreadsheets contain some unpredicable formats.
Can you tell me how to format the date in UiPath from the excell file when the string looks like this ? : "[$-14297499]dd/mm/yyyy hh:mm"