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

Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
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



Thanks that was what i needed