i would like to store a birthdate in mysql.
if the user enters the birthdate in a text field as mm/dd/year, can that be converted to a datetime?
yes
https://documentation.xojo.com/api/data_types/datetime.html#datetime-fromstring
there are methods .FromString
and .ToString
see also Locale.Current
if you like to store a string instead of date there is .SQLDate
1 Like