Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting Crystal to return last six months
Message
From
08/03/2005 10:50:53
James Warren
Audat Enterprise
Okemos, Michigan, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Getting Crystal to return last six months
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00993658
Message ID:
00993658
Views:
48
I have tried to write and SQL that cyrstal would like, using dateadd
shipdt is a date field
Where shipdt >= dateadd(m,-6,currdate) gives me a date overflow error.

What am I doing wrong?
Thanks
Jim
Next
Reply
Map
View

Click here to load this message in the networking platform