Crystal Reports String to Date Issue

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: String to Date Issue
	<< Prev Page of 3

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Nov 2014 at 11:45am
	remove it from the select statement create a formula field with datediff("d",cdate(right({WC4U999S.WS_DATE},5)+"-"+left({WC4U999S.WS_DATE},4)),CurrentDate) place that formula field on the detail section and see if it is giving your the correct date field and it is running ok. Edited by DBlank - 14 Nov 2014 at 11:45am
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 14 Nov 2014 at 12:20pm
	its still returning all the data in the table instaed of the current day
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 17 Nov 2014 at 9:44am
	try and reverse the conversion to see if it speeds up your select or stops a bad string to date data conversion {WC4U999S.FIRSTNAME} <> "BATCH" and *{WC4U999S.WS_DATE}= totext(CurrentDate,"yyyy-MM-dd"* and {WC4U999S.GROUPCD} <> "AWD FACIL" and not ({WC4U999S.USERID} like ["SCANNER", "SRVR"]) and {@Status Change} in ["Create Work", "Status Change"]
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 18 Nov 2014 at 12:14pm
	Hey that worked. Thanks so much for your help!
	IP Logged

<< Prev Page of 3

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.