The DATEVALUE function helps convert dates imported from external sources that are in text format to a proper date format recognizable by Excel for further analysis. Formula =DATEVALUE(date_text) The DATEVALUE function includes the following arguments: Date_text – This is a required argument. It is the text that represents a date in an Excel ... Function SQLDate(d) SQLDate = WorksheetFunction.Text(d, "yyyy-mm-dd hh:MM:ss") End Function or else if staging table is an option, you could convert Excel date to string using TEXT(d,"dd mmmm yyyy hh:mm:ss"). once the data is in staging table, you may write appropriate SQL statement to insert into correct table.

Jan 28, 2019 · Converting Forced Text to Numbers. ... If your entry can be translated as a number or a date, then Excel treats it that way. ... Excel displays the Convert Text to ... Although Wufoo’s report text values can’t be used in Excel as-is, here’s a quick and easy way to convert the timestamps from your Wufoo report to the standard Excel date format. On your Excel worksheet, just set up a new column with cells that contain the formula: =VALUE(xxx) …where xxx is the cell that contains the Wufoo Timestamp.