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

[@henrikn7665]

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!

[@andersjensenorg]

Hey Henrik. First of all, sorry for the late reply. And thank you so much for the nice words 😊 Kind regards, Anders

[@manazirchishti3319]

The Best approach i have ever seen.

[@andersjensenorg]

Hey Manazir. Thanks a lot - that's a big compliment :) Have a great day. Kind regards, Anders

[@Idontknow819918]

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

[@andersjensenorg]

Hahaha, what a nice message to receive. Thank you, thank you! Kind regards, Anders

[@aleksandrpantsesnyi883]

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

[@andersjensenorg]

Hey Aleksandr. Thanks a lot!! Looking back I think the content of it is great, but the sound could be better. Exactly that I'm trying to better in my new videos :) Kind regards, Anders

[@namratabuch6391]

Thank you for the solution

[@andersjensenorg]

You're very welcome, Namrata Buch - your support helps me a lot 😍

[@anuv4085]

Thank you so much for such a wonderful video

[@andersjensenorg]

You're very welcome, anu! 🤩

[@abhinavshukla5628]

Excellent as usual.

[@andersjensenorg]

You're very welcome, Abhinav Shukla - your support helps me a lot 😍

[@aakashpoly]

Hi Anders, I have followed the steps you have mentioned in the video and below is the error I am getting : 21.2.0-beta.44+Branch.release-v21.2.0. Source: Format Value Message: Cannot convert Generic Value to System.DateTime Exception Type: System.InvalidOperationException Data I was trying to convert is : "2/28/2021 12:00:00 AM" Format I have selected : MM/dd/yyyy

[@andersjensenorg]

Hey Aakash. Check this: kzbin.info/www/bejne/nWLLoHWkhKupmKM and have a great sunday 🙂 Kind regards, Anders

[@aakashpoly]

@@andersjensenorg Still getting the same error :(

[@IPIX360]

Exactly the same issue here (using Studio 2021 4.3). The sugested solution/video doesn't work.

[@mariajoseceballosjara1750]

THANK YOU!!!!

[@andersjensenorg]

You're very welcome, MARIA JOSE CEBALLOS JARA - your support helps me a lot 😍

[@fouried96]

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

[@andersjensenorg]

Hey Daniel. First of all sorry for the very late reply. Then check this video: kzbin.info/www/bejne/rYXJgqaMg66ZfsU Let me know, if that helps? Kind regards, Anders

[@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

[@andersjensenorg]

Hey Snipa Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@radenbayuherlambang3898]

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) ?

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ashwinswain1649]

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🙏🙏

[@andersjensenorg]

Hey Ashwin. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@neek103]

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

[@andersjensenorg]

Sure, have you seen this: kzbin.info/www/bejne/qJybmWZ9nMdsm9k That will teach you to do datetime operations :) Kind regards, Anders

[@anandkumar-hc6fw]

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. ????

[@andersjensenorg]

Hey Anand. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@babafakruddin5460]

How to append the excel sheet

[@andersjensenorg]

Hey Baba Fakruddin Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@mscoder9902]

Thanks , how I can wrote data in excel?

[@andersjensenorg]

Hey MS CODER Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@nagaraju5556]

Thank you....

[@KunalKumar-tt4bt]

Cannot convert to datetime error

[@andersjensenorg]

Hey Kunal, did you solve this? Kind regards, Anders

[@Maeicis]

Get Row Item as a String Variable and convert it in an Assign Activity like this: "Convert.ToDateTime(YourStringVariable).ToString("dd.MM.yyyy")"

[@plasaferstone3374]

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

[@andersjensenorg]

Hey Plasafer. Can you give me the equivalent timestamp in the video, when this error occurs? Kind regards, Anders

[@plasaferstone3374]

As I am using 2020.6.0 beta.93, there is no worrying in formatting the right data, Thank you for the tutorial!!!

[@andersjensenorg]

Awesome 😊

[@plasaferstone3374]

@@andersjensenorgThanks a lot Anders!

[@sherlinsusanna8816]

@@andersjensenorg Hi, I'm facing the same error. Format Value: Cannot convert Generic Value to System.DateTime. Timestamp in the video is 6:18

[@mikeadams4470]

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"

[@andersjensenorg]

Hey Mike. You can apply Regex: kzbin.info/www/bejne/jIe1lZ13l82Jgrc I've created this RegEx pattern for you: (?

[@mikeadams4470]

O I see. ...Excellent and thank you very much @@andersjensenorg

[@andremariano3235]

Thanks a Lot!

[@andersjensenorg]

You're very welcome 🤗