Hi, I have a vba query that i would like to create a column for date. May I ask any idea on how to do this in my query. thanks. below is my query: i wanted to include the todaydate as field column. TodayDate = Format(Date, "dd-mmm") sqlstr = "SELECT e.DAX_ITEMTYPE, e.DAX_WHSE, e.DAX_LOCATION " sqlstr = sqlstr & "FROM [1.reference$] e " sqlstr = sqlstr & "WHERE isnull(e.Location) " sqlstr = sqlstr & "GROUP BY e.DAX_ITEMTYPE, e.DAX_WHSE, e.DAX_LOCATION"

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel VBA query with Date as field

Thread starter Nicole1023
Start date Sep 24, 2014

Nicole1023

New Member

Sep 24, 2014

Hi,

I have a vba query that i would like to create a column for date. May I ask any idea on how to do this in my query. thanks.

below is my query: i wanted to include the todaydate as field column.

Code:

    TodayDate = Format(Date, "dd-mmm")
    
    sqlstr = "SELECT e.DAX_ITEMTYPE, e.DAX_WHSE, e.DAX_LOCATION "
    sqlstr = sqlstr & "FROM [1.reference$] e "
    sqlstr = sqlstr & "WHERE isnull(e.Location) "
    sqlstr = sqlstr & "GROUP BY e.DAX_ITEMTYPE, e.DAX_WHSE, e.DAX_LOCATION"