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 Westi 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
Feb 20, 2008
17
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
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
500
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
346
doodledump
D
B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
247
hilfy
hilfy
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
274
socalvelo
socalvelo
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
199
PJ222
PJ222

Part and Inventory Search

Sponsor

Back
Top