Read from Excel Date 11/21/1967 into website drop down

Hi all,
I hope everyone is safe and Healthy.
I have a data table of birth days in Month day Year format “11/21/1967”
the web site I am working with wants month Jan-Dec selector box day sector integer number year selector integer number. (Screen shot below)
Site Mont day year
Question
How do I take the read in data form Excel table then convert it or have the site chose the correct data paramotors?

@pkramer

Check as below for your reference

Check below for converting date values

Hope this may help you

Thanks

parse the string to a datetime:
myDate = CDate(“11/21/1967”)
or with DateTime.ParseExact Method for having more in control

getting the different parts we can do:
myDate.Year.toString
myDate.Month.toString
myDate.Day.toString

grafik

1 Like

Hi @pkramer ,

If your issue is not resolved, please answer below questions:

  1. Does month dropdown have options like Jan, Feb, Mar Or January, February, March?

  2. Does your date look like 05/01/2020 or 5/1/2020 ?(Month/Day/Year)

  1. yes dropdown one has a Jan to dec dropdown option
  2. yes the second drop down is day in 01 through 31 format
  3. Third drop down is 1900 through 2021

d = Date.Parse(“11/21/1967”)

day = d.ToString(“dd”)
month = d.ToString(“MMM”)
year = d.ToString(“yyyy”)

Thank you!