1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Querying dates from dbf in macro

Discussion in 'Visual Basic ( VB )' started by ill_comms, Feb 21, 2011.

  1. ill_comms

    ill_comms New Member

    Joined:
    Feb 16, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi All,

    In my code I have this select statement that I'm trying to put together but the query is recognizing the day as the month in the from_date and getting it right in the to_date, I guess for an obvious reason there's no 13th month. I've tried using '-' instead of '/'.

    I basically want it to recognize it as dd/mm/yyy

    Any advice would be greatly appreciated!
    Hayden


    Code:
    'dd/mm/yyyy
    from_date = "11/01/2011"
    to_date = "13/01/2011"
    
    Set cn = CreateObject("ADODB.Connection")
    Set rs = CreateObject("ADODB.Recordset")
    cn.Open "driver={Microsoft dBase Driver (*.dbf)}; driverid=277;dbq=" + rootdir + "\MAINT\"
        
    c1SQL = "Select OccurDate from LnMt.dbf Where OccurDate >= #" + temp_date + "# And OccurDate <= #" + to_date + "#"
        
    rs.Open c1SQL, cn, , , adCmdText
     
  2. ill_comms

    ill_comms New Member

    Joined:
    Feb 16, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Also I'm not sure if it is the variable or the field that it's reversing, they are both type in correctly. There are dates entered in the OccurDate field 12/01/2011.
     

Share This Page