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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date

Status
Not open for further replies.
EscapeUK

EscapeUK

Programmer
Jul 7, 2000
438
GB
Using Query Designer and trying to use a data as a parameter.

The DB i am using is an Oracle one and the dates are in the format of 05/05/2001 07:55:48

How do i use this in my SQL statement

desperate help needed.
 
Sort by date Sort by votes
Add a datetime range parameter to the Crystal Report, and add something akin to the following in the record selection criteria:

{MyTable.MyDatetimeField} in {?MyDateParm}

Crystal should handle the rest for you.

-k kai@informeddatadecisions.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
429
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
273
doodledump
D
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
159
PJ222
PJ222
ejastia
  • Locked
  • Question
date format spacing 1
Replies
4
Views
235
ejastia
ejastia
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
256
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top