V4RB2 Checking date in SQL

[Claudius Sailer]

Hi,

I made BugReport #647


Am 09. Apr 2005 um 18:16 Uhr schrieb Claudius Sailer:

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>