datetime format

  1. S

    Extracting Integer from DateTime values

    Hi all, Hopefully its just a quick solution needed here: I have a table column that contains imported datetime values. I have formatted them as 'dd-mmm-yy', and am trying to extract counts that fall between different date ranges. However, I've noticed that the values are not truly integers...
  2. N

    SQL data conversion error for Excel VBA

    Hello I would like to copy a recordset from a Oracle RDB Driver into Excel, however I am having problems with my DateTime variable. I would like to open an SQL string similar to the following : strSQL = "SELECT TRANSACTION_DATE FROM FINANCIAL_TRANSACTION WHERE TRANSACTION_DATE > '14/12/2014'"...
  3. R

    Strange Date Format 11/4/14, 1:09 PM will not convert to Excel Date Time due to comma placement

    A popular product has an Export to Excel with a single column for Date / Time. The format shown has the date [comma] Time. It won't convert to a Date date type due to the comma. A popular software tool takes this data off of the internet and converts it to this text string. I can manually use...
  4. D

    Excel VBA SQL Query - Format Date Output

    I'm using a SQL query in VBA to select and join data spread across two worksheets and then outputting the results to a third worksheet. One of the fields is an Excel Date. On the source worksheet the value is: 9/25/2008 21:05 On the output worksheet the result is: 38996.402222 I would like...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top