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 Mike Lewis 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
Jul 7, 2005
28
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
Passing date range formula from main report to sub report
Replies
2
Views
249
lbass
lbass
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
108
hilfy
hilfy
Mark.rooker
  • Locked
  • Question
Find closest date
Replies
1
Views
127
lbass
lbass
grecon
  • Locked
  • Question
Cross Tab date Selection?
Replies
1
Views
104
lbass
lbass
hpl2001
  • Locked
  • Question
Calculating totals across a date range
Replies
10
Views
193
hpl2001
hpl2001

Part and Inventory Search

Sponsor

Back
Top