How do I convert various string date formats to SQLDate string?
10-19-19 to 2019-10-19
10-19-2019 to 2019-10-19
Oct 19, 2019 to 2019-10-19
etc.
I currently use this in a method:
Dim d As New date
Dim theTrueBool As Boolean
theTruebool = ParseDate (dateTxt, d)
Return d.SQLDate
https://documentation.xojo.com/api/data_types/datetime.html#datetime-sqldateTime
Var d As DateTime = DateTime.Now
Label1.Value = d.SQLDateTime
This gives not the corect format?
MarkusR
(MarkusR)
October 17, 2019, 12:26pm
3
I did look at DateTime.fromstring earlier but I didn’t get what I wanted, but looking at it again and doing some trial and error work I have it working as i want.