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)
Question
How do I take the read in data form Excel table then convert it or have the site chose the correct data paramotors?
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
1 Like
Hi @pkramer ,
If your issue is not resolved, please answer below questions:
-
Does month dropdown have options like Jan, Feb, Mar Or January, February, March?
-
Does your date look like 05/01/2020 or 5/1/2020 ?(Month/Day/Year)
- yes dropdown one has a Jan to dec dropdown option
- yes the second drop down is day in 01 through 31 format
- 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!