How to select dates from a Date Picker with UiPath - Full Tutorial

[@ashokdondapati7666]

Great Anders...👍👍👍

[@andersjensenorg]

Thank you very much, Ashok 🙂

[@23Ashishonelove]

Thank you Anders! This is exactly what I needed and this tutorial solved my project's calendar issue.🙂 Cheers mate!

[@mopurkishore4600]

can you post some real time scenarios of R.P.A?I am new to R.P.A

[@23Ashishonelove]

Did you complete academy course?

[@andersjensenorg]

Great to hear, Ashish. Have a good day 🙂 Kind regards, Anders

[@andersjensenorg]

@@mopurkishore4600 Hey Mopur. In what direction? You can try to check this out, kzbin.info/www/bejne/jXPWhZykftaqobs Kind regards, Anders

[@mopurkishore4600]

Completed basic topics excel, data table,screen scrapping,input output methods etc still learning

[@Pijus67]

Great job. Exactly what I needed. Different picker, from a corporate app, but equally usefull. Thank you very much for sharing this

[@andersjensenorg]

Awesome Pijus 😊

[@opowermate]

Hi, great video! Can you please make a video teaching how to select dates from a Date Picker with Power automate?

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

[@nocodeyuan]

Dear Anders, great video! Could demo date picker in PowerAutomateDesktop in next video? Scenario is exporting Zoom usage report, A few more challenge: 1. fliping through months with button, not dropdown menu, 2. How to select day 1 and last day of month. (e.g. Feb)

[@andersjensenorg]

Hey Kevin. Thanks a lot! And sure. I will make a great batch of Power Automate videos within the next month :) Kind regards, Anders

[@MrSirRise]

Just Help me a lot!

[@andersjensenorg]

Thanks a ton, Nuno! 😊

[@dineshreddy2145]

Hey Anders..!! Thanks very much,you are posting good stuff. Need a suggestion I have a text file which is of 2GB size. I've to load this data and convert it to spreadsheet. It's taking a lot of time also sometimes facing robot issue. How to reduce the time and process it quickly.? Thanks

[@andersjensenorg]

Hey Dinesh. Thanks, I'm glad you're saying that 🙂 I've actually not came across this problem before. Do you load all of your data in the beginning and do you need it all or just some of it? Kind regards, Anders

[@dineshreddy2145]

@@andersjensenorg I ve to load all of the data and move it to a spreadsheet. And from spreadsheet I've to use the data wherever it's required

[@kevinmok2011]

Hi, when I select 30/07/2020, it would select the date of 30/06/2020 because the calendar select the first "30" of on 'July'. May I know that know that how to solve it?

[@andersjensenorg]

Hey Mok. Can you link to the calendar, you try to automate? Kind regards, Anders

[@bvvrstrinadh2509]

video is helpful. However can you suggest how to select the specific date by its colour?

[@andersjensenorg]

Hey BVVRS TRINADH Thanks for writing. I'm getting more than 50 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

[@nirmalak7020]

Please create a video for select date range from web browser and make it dynamic with UiPath. like i want to select past 6 months from today date. suppose today is 13/12/2021 then in date piker it should select 13/06/2021

[@andersjensenorg]

Hey Nirmala K 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

[@NaveenKumar-gg1fd]

Great it's working...But having problems if I'm type date less then 10...It mens from 1 to 9 not working...Also I 've check 01, 02, or 09...Plz help me

[@andersjensenorg]

Hey Naveen. 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

[@zero6699his]

Hi anders, Thanks for your all efforts.. I have questions: I have 500 employee to renew thier membership and the website asking birthday for each employee.. how to pick different birthday for each employee from excel to website ? Thanks in advance

[@andersjensenorg]

Hey Hussein. Thank you! We need to split the questions up, otherwise it's hard to answer. First of all read the excel into a data table with a Read Range. Then For Each Row, Type into = row.item("yourBirthdayColumnName").ToString. If we have another data format, we need to format the date to the format of the website first. Check this: kzbin.info/www/bejne/qJybmWZ9nMdsm9k Kind regards, Anders

[@jam05eun]

Perfect! Just what I need on my new bot :)

[@andersjensenorg]

Hey jam05eurn. Thank you very much 😊 Let me know, if you have any questions. Kind regards, Anders

[@GKUniverse207]

Hi Anders...My requirement is to always select start date as "Yesterday" and end date as "Today" from calendar ??

[@andersjensenorg]

Hey AG, check this kzbin.info/www/bejne/mmSrhnZsqqqGbK8 🙂 Did that solve it for you? Kind regards, Anders

[@omarmoustafa3972]

best of the best!!

[@andersjensenorg]

Hey Omar. Thank you 🙂👍🤩 Kind regards, Anders

[@williamvargas9993]

Thanks, works for me UI

[@andersjensenorg]

You're very welcome, William Vargas - your support helps me a lot 😍

[@itsmechethan6105]

how to select the hover dropdown list how to handle it can you please make video for that

[@andersjensenorg]

Hey Chetan. Thanks a lot for being so active 🙂👍 Can you give me a link to such a dropdown? Kind regards, Anders

[@itsmechethan6105]

@@andersjensenorgyou can see in the Uiforum only

[@sarahliyanamohdjohari9826]

I need to create automation for Resignation process. But based on their type of employment their notice period varies. Confirmed employees 3 months, Probation 2 weeks , Clerical 8 weeks. Im having a hard time getting the correct last emploment date as some months is 31 and some 30 days. So adding 90 days is not accurate. Eg: 21April 2021 - 20 July (90 days) but 3 May - 2 Aug (91 days). Any help how to make it accurate?

[@andersjensenorg]

Hey Sarah. 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

[@manideepak6820]

Is there any vedio in power automate for date picker

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

[@loganayakisathish7300]

Hi Anders, How to do select date from the date picker in Modern design Activity?

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

[@marcosperalelena5253]

Hi Anders, I am trying to follow the process but I can not find variables strInput and strMonthYear in Uipath. Where can I find them?

[@andersjensenorg]

Hey Marcos. You need to create them youself (and can call them what you want). Either create them with ctrl+k in the field and type the name OR create it in variable manager. Can you solve it? Otherwise let me know. Kind regards, Anders

[@marcosperalelena5253]

@@andersjensenorg Thanks a lot, the problem was not strInput nor strMonthYear. The real problem was ctrl+k. I write down instead Set Variable: strInput and any variable was created. Kind regards, I am just very new

[@andersjensenorg]

Nice 🙂 I make a note to myself, that I can explain that part better in the future. If you have questions/suggestions to future videos, just let me know. I try to answer most of the questions. Kind regards, Anders

[@mywork9640]

good

[@andersjensenorg]

Thanks a lot 🙌

[@josep7376]

I had a problem with one digit days. I have solved with an IF condition strDay.Substring(0,1).tostring = "0" and if true, creating a new string with substring(1,1). It runs well but probably there is an easier solution :) There is another problem when there are two days form different month in the same date picker table. For instance, it will pick the first "30" at row 2, but the correct day is in the row 6 or 7. I will try later to find a solution. Do you have a tip?

[@andersjensenorg]

Hey Josep. Thanks for the question and sorry for the late reply. 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

[@josep7376]

@@andersjensenorg Enjoy your paternity. Congratulations!

[@miriamolvera9440]

Hi Anders, I am traying with this tutorial but, show a message "The UIElement is no longer valid". ¿Could you tell me how can I fixed? Thank you in advance

[@andersjensenorg]

Hey Miriam Olvera 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

[@mauriciorojas3318]

I am using UiPath StudioX, but the Edit Selector is not available in the 3 ribbons :( what can I do?

[@andersjensenorg]

Hey Mauricio Rojas Thanks for writing. I'm getting more than 50 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

[@kunmark939]

Hi Mr Jensen, when i added the code to convert the date to string in the assign value box, i get an error message " Cannot assign from type 'System.String' to type 'UiPath.Core.GenericValue' in Assign activity 'Assign'. What could be the error please?

[@andersjensenorg]

Hey Kun Mark 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

[@Amish-i3y]

Can we use this solution for selection of date of birth

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

[@anandkumar-hc6fw]

hi Anders...! your video is very Good, but when am i trying to input data from excel like column name Date like--21/05/2021, 30/12/2020, 12/06/2021 row("Date") its showing error string is not valid . please give solution to me my project is based on this .

[@andersjensenorg]

Hey anand kumar 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

[@kruthikapampattiwar7796]

hi can you plz work on the use case of make my trip application by entering source ,destination and date of journey from excel sheet, search for flights and get the price of first flight , capture it back in excel sheet

[@andersjensenorg]

Hey kruthika pampattiwar 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

[@jiteshrocks6694]

can you plz work on the use case of make my trip application by entering source ,destination and date of journey from excel sheet, search for flights and get the price of first flight , capture it back in excel sheet

[@andersjensenorg]

Hey Jitesh. At what site? Kind regards, Anders

[@jiteshrocks6694]

MakeMyTrip.com

[@jungjungho2204]

have message box write " This control does not support select item" how to do? thanks

[@andersjensenorg]

Then it's not a drop down. Maybe you can use Type Into? Kind regards, Anders

[@jungjungho2204]

@@andersjensenorg thank your answer i'll try

[@nidhij2002]

How to convert the Month(number) into Text Like I have value of month as '8' but I need to convert it in 'August'.

[@andersjensenorg]

Hey Nidhi Jain 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

[@tejaswinerella5223]

Hi, Anders can you share this line " l "" of click button...

[@andersjensenorg]

Hey tejaswi, do you mean this: "" ? Or do you want the entire workflow? Kind regards, Anders

[@tejaswinerella5223]

@@andersjensenorg this one

[@tejaswinerella5223]

@@andersjensenorg thank you

[@madhuriphadale5059]

Hi, I did same step but for the last step I'm getting error.. as my selector tag is anchor.. I'm trying on this calendar demos.telerik.com/aspnet-ajax/calendar/overview/defaultcs.aspx

[@andersjensenorg]

Hey Madhuri. If you change the selector to "" where the variable intDay is an integer holding the value for the day, you wanna click. Let me know, if that helps 🙂 Kind regards, Anders

[@sayalichincholikar3272]

Hi Anders, I have tried the date picker with goibibo (www.goibibo.com/) site and there is no dropdown list to select month and year instead of that there is right and left arrow to move forward and backward to select month and year so how can I automate that? Can you please help. I would be very grateful.

[@IPIX360]

I faced the same problem with a different calendar. How did you solve it?

[@andersjensenorg]

Hey Sayali Chincholikar 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

[@jeevijeeva1548]

hi how to read a data from dynamically changing records of weather bar graph,for suggestion u can refer this link: darksky.net/forecast/40.7127,-74.0059/us12/en ,where i have read data from bar graph representation

[@andersjensenorg]

Hey jeevi jeeva 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