How to enter a date into website based on values read from Excel

Help Studio
1

Hi, so I want to create new entries on a website based on values I read from an Excel spreadsheet. One of the fields is a date field with a calendar view:

Date entry textbox with calendar view

How can I enter a date stored in a data table into the field by using the calendar view

2

@eugenecoetzee989

Have you tried by using

Type into activity

By converting the date format coming from the excel to the calendar format in website

Datetime.parseexact("10/11/2023,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).tostring(“yyyy/MM/dd”)

You can replace this “10/11/2023” with your variable