Link to home
Start Free TrialLog in
Avatar of Danny Kon
Danny KonFlag for Netherlands

asked on

SQL Query to get rows from today

I get in this database everyday orders but i only want to see the orders for today.
__
SELECT     tblRelatie.fldRelatiecode, tblVerkoopOrder.fldOrdernummer, tblArtikel.fldArtikelcode, tblArtikel.fldOmschrijving, tblVerkoopOrder.fldOmschrijving AS Expr1,
                      tblRelatie.fldNaam, tblVerkoopOrder.fldAfhandelStatus, tblVerkoopOrder.fldWerkbonAfgedrukt, tblVerkoopOrder.fldOfferteAfgedrukt, tblVerkoopOrder.fldPakbonAfgedrukt,
                      tblVerkoopOrder.fldAfhaalbonAfgedrukt, tblVerkoopOrder.fldDatum
FROM         tblVerkoopOrder INNER JOIN
                      tblVerkoopOrderRegel ON tblVerkoopOrder.fldVerkoopOrderID = tblVerkoopOrderRegel.fldVerkoopOrderID INNER JOIN
                      tblArtikel ON tblVerkoopOrderRegel.fldArtikelID = tblArtikel.fldArtikelID INNER JOIN
                      tblRelatie ON tblVerkoopOrder.fldRelatieID = tblRelatie.fldRelatieID
                     
                 
ORDER BY tblVerkoopOrder.fldNaam, tblVerkoopOrder.fldDatum
__
tblVerkoopOrder.fldDatum has to be the date for today

Thanks in advance

Danny
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Danny Kon

ASKER

Vitor,

Thanks that was what i needed