Dim sourceSheet As Worksheet Dim dataSheet As Worksheet Dim dat As Double Dim CN As String Dim BN As String Dim ChNO As Long Dim Ma1 As String Dim Qu1 As Integer Dim Un1 As String Dim Ma2 As String Dim Qu2 As Integer Dim Un2 As String Dim Ma3 As String Dim Qu3 As […]

Dim sourceSheet As Worksheet Dim dataSheet As Worksheet Dim dat As Double Dim CN As String Dim BN As String Dim ChNO As Long Dim Ma1 As String Dim Qu1 As Integer Dim Un1 As String Dim Ma2 As String Dim Qu2 As Integer Dim Un2 As String Dim Ma3 As String Dim Qu3 As […]

I’m using SQL in an Excel program to create a report for products in a store which have not been ordered in 6 months or more. Most of the data is in a single table so it works fine as below:

I’m use an SQL to Excel program to create a report for products in a store which have not been ordered in 6 months or more. Most of the data is in a single table so it works fine as below:

I’m running into a problem with processing my data in SQL, how do i go about converting data in the cell as shown below into HH:MM. I know this is in text and not formatted as date.