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!

String Date to Date Field 1

Status
Not open for further replies.
Penny001

Penny001

Programmer
Joined
Feb 20, 2008
Messages
17
Location
US
I am having a problem making a String Date field to a true Date field so I can compare with other dates.

I'm using Crystal 7.

I've tried DSToDate and the new field appears to be a date field but there is no data in it.

Please help....
 
Sort by date Sort by votes
Not sure what functions are avaialable in CR 7 as its over 10 years old!!

But this should work, create formula

@Date

Date(tonumber(left(DateString,4)), tonumber(mid(DateString,5,2)), tonumber(right(DateString,2)))


Ian

 
Upvote 0 Downvote
THANK YOU SO MUCH!! IT WORKED.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
D
  • Locked
  • Question Question
Comparing two Date Ranges
Replies
0
Views
630
doodledump
D
D
  • Locked
  • Question Question
Dynamic field height in crosstab?
Replies
0
Views
173
doodledump
D
B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
625
hilfy
hilfy
socalvelo
  • Locked
  • Question Question
Extract Phone Numbers from Text Field
Replies
0
Views
716
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top