How to select a particular row option in a web page?

[kishore.shetty]

I have a excel sheet with attendance i have to update it to attendance web page to correct date.
the date and option selectors are not not same. how can i match date from excel and then go to that date in web page and select the update option?

[varunk (Varun Kumar)]

Hi @kishore.shetty,

You can convert the date format in excel as how it looks like in web page.
Then you can update in web page

[kishore.shetty]

my excel date format is MM/dd/yyyy hh:mm:ss how do i change it to dd/MM MMM
Ex:( 02/05 Thu)

[lakshman (Ganta lakshman)]

@kishore.shetty

Try this:

DateTime.ParseExact(“05/14/2019 02:32:20” , “MM/dd/yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM dddd”)