Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL command

Status
Not open for further replies.
makk07

makk07

Programmer
Aug 22, 2007
24
US
Hi Everyone,

How to write a SQL command for a crystal report for retrieving records only for last 7 days from a SQL Server database.
I am using crystal reports XI.Please help me out, I am new to reporting world also its urgent.

Thanks in advance for help
mak
 
Sort by date Sort by votes
You don't need SQL, Crystal selection will do it OK. Something like
Code: 
DateDiff ("d", {your.date1},  currentdate) <= 6
This assumes you mean today and the last 6 days, and that no dates are in the future.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
SQL EXPRESSION
Replies
5
Views
199
elly00
elly00
crytalbria
  • Locked
  • Question
SQL Expression Field wtih multiple FROMs
Replies
3
Views
296
hilfy
hilfy
Cryst4LN00B
  • Locked
  • Question
Convert Query SQL into Select Expert Crystal
Replies
4
Views
163
kray4660
kray4660
azeemkhn
  • Locked
  • Question
is there any function in SQL SERVER
Replies
4
Views
91
kray4660
kray4660
BeeBear2
  • Locked
  • Question
Passing Multi-Value Parameter result to Crystal Command Sql - Can it be done??
Replies
10
Views
327
BeeBear2
BeeBear2

Part and Inventory Search

Sponsor

Back
Top