
Filter dates between VB 6.0 and CR 6.0 from *.qry
Quique,
You probably have datetime value in your database, and then compare it with the
date. In this case the comparison should be
date_to_check < Next_after_to_date
Hope this helps
Boris
cc: (bcc: Boris Mandel/New Jersey/ACMC)
Subject: Filter dates between VB 6.0 and CR 6.0 from *.qry
Message from the Deja.com forum:
microsoft.public.vb.crystal
Your subscription is set to individual email delivery
oO---------------------------------------------------------Oo
SPONSOR
No gimmicks - just great value! Long distance with Qwest.
State-to-state calls 9c cents a minute, all day, every day with NO
monthly fee. Sign up today and start experiencing the difference.
http://www.deja.com/jump/http://www.qhome.net/dejanews/dj01/offer.jhtml
oO---------------------------------------------------------Oo
Hi guys.
I have a problem with dates in CR.
My reports are built with Crystal Query designer
when I insert the fields on my report the field change Datetime to a string.
I use DTSToDate(DateTimeString) function to change that string field to
date.
The problem is that when I ask from VB code to recover all the registers
between two dates, as follows,
date1>= date(1999,10,10)
date2<=date(1999,11,11)
the registers which date is 1999,11,11 doesnt appear in my report.
thanks in advance
- Quique -
_____________________________________________________________
Deja.com: Share what you know. Learn what you don't.
http://www.deja.com/
* To modify or remove your subscription, go to
http://www.deja.com/edit_sub.xp?group=microsoft.public.vb.crystal
* Read this thread at
http://www.deja.com/thread/%3CeYQy%23oFz%23GA.263%40cppssbbsa05%3E