Search a date from calendar

[sgarg]

Hi,

I have an excel in which I have a column named “Date”. Now the process I have to automate is, to select the date from the excel and book an appointment in Portal’s Calendar.

But the format in Excel is eg 15-Oct-23 and form on portal has a fields with calendar icon from which I have to select 15-Oct-23.

Please suggest how can we do this

Thanks in advance

[Shiva_Nikhil]

@sgarg

Can you provide the format which it was in the form

In the above which you have mentioned are in the same format

Or you can use below expression

stroutput=DateTime.ParseExact(strDate,“dd-MMM-yyyy”,System.GLobalization.CultureInfo.Invariant culture).ToString(“dd-MMM-yy”)

Here strdate is your input which is coming from excel

Cheers

[mkankatala (Mahesh Kankatala)]

Hi @sgarg

If there is any possible to type the date in the Calendar field, In that case you can use the Type into activity.

Hope it helps!!

[supriya117 (Supriya Allada)]

Hi @sgarg

Check this:

How to pick dates from a date picker in Uipath

I have a datepicker like this on my web page [Screenshot (113)] I want to select the first date of each month. how can I do this ? I directly tried using the type into activity but somehow it doesn’t work because upon clicking on the textbox (which is appearing above the calendar where the date is displayed), directly the calendar opens. Also If I had to select the last date of each month. How do I do That ?

Uipath Date Picker Latest Dynamic Design

[sgarg]

@Shiva_Nikhil

stroutput=DateTime.ParseExact(strDate,“dd-MMM-yyyy”,System.GLobalization.CultureInfo.Invariant culture).ToString(“dd-MMM-yy”)

Hi,
Date Format in Excel is :

And Date format in application is:

And when I have tried the expression given by you in Studio, to parse the date of excel in calendar format got below syntax error, Please correct where I went wrong:

[Shiva_Nikhil]

@sgarg

there should be no space in inavrainatCulture can you check it once

cheers

[lrtetala (Lakshman Reddy)]

Hi @sgarg

Try this

DateTime.ParseExact(Input.ToString,"dd/M/yyyy",System.GLobalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")

You can pass this variable using type into activity

[Shiva_Nikhil]

@sgarg

DateTime.ParseExact(inputstr,“dd/M/yyyy”,system.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

cheers

[sgarg]

@Shiva_Nikhil

DateTime.ParseExact(inputstr,“dd/M/yyyy”,system.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

I run your expression, but got following issue:

[Shiva_Nikhil]

@sgarg

type the expression, don’t copy and paste the expression

the error is because you have copied and pasted the expression

cheers

[lrtetala (Lakshman Reddy)]

@sgarg

Don’t copy and paste the syntax there may be a error with double quotes please retype double quotes

[sgarg]

Thanks for your help,it worked for me