Graphics

 View Only

  • 1.  query with curdat() and now()

    Posted 08-10-2016 11:45
    Hi there,

    I'm using an ADO connection within the sequenser to import some information.

    This is all working great, but when I'm trying to use query with "CURDAT()" or "NOW()", im getting no result. but when I search for an exact name, I'm getting an result.

    working: Query = SELECT top(1) text FROM db WHERE date= '2016-08-10'

    not working: Query = SELECT top(1) text FROM db WHERE date= CURDATE()

    Anybody got a clue?


  • 2.  RE: query with curdat() and now()

    Posted 08-10-2016 14:36
    got it... it's not curdat() but getdate()
    #XPression