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

Date conversion

Status
Not open for further replies.
anushka04

anushka04

Technical User
Joined
Jul 7, 2005
Messages
28
Location
GB
How can I convert data in a text field to date and compare with date parameter filed to return data only related to the parameter date?
 
Sort by date Sort by votes
Try
Code: 
Cdate({your.string}) = ?ParamDate
If that does not work, comment out the selection and display Cdate({your.string}) to check thatit is OK.

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

Similar threads

rwwagner
  • Locked
  • Question Question
Passing date range formula from main report to sub report
Replies
2
Views
786
lbass
lbass
PeteyN.O
  • Locked
  • Question Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
434
hilfy
hilfy
Mark.rooker
  • Locked
  • Question Question
Find closest date
Replies
1
Views
390
lbass
lbass
grecon
  • Locked
  • Question Question
Cross Tab date Selection?
Replies
1
Views
419
lbass
lbass
hpl2001
  • Locked
  • Question Question
Calculating totals across a date range
Replies
10
Views
730
hpl2001
hpl2001

Part and Inventory Search

Sponsor

Back
Top