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
Hey Daniel. First of all sorry for the very late reply. Then check this video: th-cam.com/video/wTfQsVNIfHc/w-d-xo.html Let me know, if that helps? Kind regards, Anders
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
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) ?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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. ????
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: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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🙏🙏
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: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
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"
![[LIVE] : ONE ลุมพินี 87 วันนี้!! คู่เอก "ก้องชัย vs โชคปรีชา"](http://i.ytimg.com/vi/YN6e7HVnekw/mqdefault.jpg)
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!
Hey Henrik. First of all, sorry for the late reply. And thank you so much for the nice words 😊 Kind regards, Anders
You Sir, are a God sent saint!!!!!! HUGE THANKS FOR SAVING MY DAY
Hahaha, what a nice message to receive. Thank you, thank you! Kind regards, Anders
The Best approach i have ever seen.
Hey Manazir. Thanks a lot - that's a big compliment :) Have a great day. Kind regards, Anders
Thank you very much !!! I tried to find how to do this and you explained it. Your tutorial is AWESOME !!!
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
Thank you for the solution
You're very welcome, Namrata Buch - your support helps me a lot 😍
Thank you so much for such a wonderful video
You're very welcome, anu! 🤩
Excellent as usual.
You're very welcome, Abhinav Shukla - your support helps me a lot 😍
THANK YOU!!!!
You're very welcome, MARIA JOSE CEBALLOS JARA - your support helps me a lot 😍
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
Hey Daniel. First of all sorry for the very late reply. Then check this video: th-cam.com/video/wTfQsVNIfHc/w-d-xo.html Let me know, if that helps? Kind regards, Anders
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
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Thank you....
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) ?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
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. ????
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: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Can you read dob from excel and calculate the age then display age in the same excel file
Sure, have you seen this: th-cam.com/video/rk8h3Ggb9ew/w-d-xo.html That will teach you to do datetime operations :) Kind regards, Anders
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🙏🙏
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: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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
Hey Aakash. Check this: th-cam.com/video/g1hoBnOFvbA/w-d-xo.html and have a great sunday 🙂 Kind regards, Anders
@@andersjensenorg Still getting the same error :(
Exactly the same issue here (using Studio 2021 4.3). The sugested solution/video doesn't work.
How to append the excel sheet
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Thanks , how I can wrote data in excel?
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Cannot convert to datetime error
Hey Kunal, did you solve this? Kind regards, Anders
Get Row Item as a String Variable and convert it in an Assign Activity like this: "Convert.ToDateTime(YourStringVariable).ToString("dd.MM.yyyy")"
Hi Anders! i have an error in this application. "Cannot Convert Generic Value into System.Date.Time"
Hey Plasafer. Can you give me the equivalent timestamp in the video, when this error occurs? Kind regards, Anders
As I am using 2020.6.0 beta.93, there is no worrying in formatting the right data, Thank you for the tutorial!!!
Awesome 😊
@@andersjensenorgThanks a lot Anders!
@@andersjensenorg Hi, I'm facing the same error. Format Value: Cannot convert Generic Value to System.DateTime. Timestamp in the video is 6:18
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"
Hey Mike. You can apply Regex: th-cam.com/video/VVRdjAbhVLU/w-d-xo.html I've created this RegEx pattern for you: (?
O I see. ...Excellent and thank you very much @@andersjensenorg
Thanks a Lot!
You're very welcome 🤗