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

SQL Date

Status
Not open for further replies.
JEnright1

JEnright1

IS-IT--Management
Nov 19, 2007
15
US
I have an SQL formula

((LAWSON.PAYMASTR.CHECK_DATE)={d '2012-07-19'}) that is not working. I am using Crystal 10. Can I create an SQL statement that would run the select statement with the check date = 7/19/2012? Thank You.
 
Sort by date Sort by votes
YOu can add a select statement directly to crystal

CHECK_DATE = date(2012, 07, 19)

or you can create a date parameter so that users can enter any date they want before report runs

Ian
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
358
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
230
doodledump
D
elly00
  • Locked
  • Question
SQL EXPRESSION
Replies
5
Views
240
elly00
elly00
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
142
PJ222
PJ222
ejastia
  • Locked
  • Question
date format spacing 1
Replies
4
Views
213
ejastia
ejastia

Part and Inventory Search

Sponsor

Back
Top