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!

Need Help Please

Status
Not open for further replies.
fhurmuzlu

fhurmuzlu

Programmer
Nov 16, 2004
52
US
I am using crystal 10 , I have WEDATE Table and Field name WEDE which is String and contains Date like(20050901)All Dates are Sunday dates .I need Formula shows Sunday Dates for each month.
 
Sort by date Sort by votes
Create a formula to convert the string to a date:

date(val({WEDATE.WEDE}[1 to 4]),val({WEDATE.WEDE}[5 to 6]), val({WEDATE.WEDE}[7 to 8]))

~Brian
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Crystal Report Help 1
Replies
2
Views
358
john432
john432
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
181
BradCustom
BradCustom
chish_nc
  • Locked
  • Question
Need help getting oldest anniversary date to show
Replies
3
Views
284
pmax9999
pmax9999
Fermo Zolli
  • Locked
  • Question
Need help with formulas
Replies
1
Views
125
kray4660
kray4660
ncchish
  • Locked
  • Question
Need help with crystal formula
Replies
3
Views
191
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top