V4RB2 Checking date in SQL
Claudius Sailer
Claudius at sailer-online.de
Sat Apr 9 18:16:31 CDT 2005
Hi,
I use follwoing Coding
SELECT B.BDatum, HK.Konto_Typ, ZK.Konto_Typ, K.Kategorie_Name,
K.Kategorie_Art, SF.SYM_NAME, F.ID, F.FName, K.LfdNr,
CASE
WHEN HK.Konto_Typ=true AND K.Kategorie_Art=1 THEN B.Betrag * (-1)
WHEN HK.Konto_Typ=false AND K.Kategorie_Art=2 THEN B.Betrag * (-1)
ELSE B.Betrag
END
FROM Buchungen B, Konten HK, Konten ZK, Kategorien K, Steuerfuchsfelder
SF, Formulare F
WHERE B.Herk_Konto=HK.RecID
AND B.Ziel_Konto=ZK.RecID
AND B.Kategorie_ID=K.RecID
AND K.SteuerFeld=SF.RecID
AND SF.FArt=F.RecID
AND B.Deleted='0'
AND B.BDatum>='01.01.2004'
AND B.BDatum<='31.12.2004'
AND HK.Konto_Typ <> ZK.Konto_Typ
ORDER BY F.ID, K.LfdNr, SF.SYM_NAME, B.BDatum
result is 0 records. I know I have. When I deactivate following rows
AND B.BDatum>='01.01.2004'
AND B.BDatum<='31.12.2004'
I get results where I also can see that I have also values in 2004.
What is my fault?
Dateformat is 1 ans separator is "."
In 1.10 this coding worked....
thanks
Claudius
More information about the Valentina
mailing list