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 Next >>

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Nov 2014 at 9:42am
	do you have more than one table involved in this report?
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 14 Nov 2014 at 9:55am
	no, just the WC4U999S table
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Nov 2014 at 9:58am
	does it run fine without the date criteria? what is the formula {@Status Change}
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 14 Nov 2014 at 10:22am
	It does run fine without the date criteria. It returns everything from the begining of time on the DB. status change formula is; {WC4U999S.FIRSTNAME} <> "BATCH" and not ({WC4U999S.USERID} like ["SCANNER", "SRVR"]) and {WC4U999S.GROUPCD} <> "AWD FACIL" and {WC4U999S.WS_DATE} < "" and {@Status Change} in ["Create Work", "Status Change"]
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Nov 2014 at 10:27am
	I think you copied the wrong formula. it may not matter. it may be hanging up on the date field conversion what does your string in the WC4U999S.WS_DATE field look like?
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 14 Nov 2014 at 10:33am
	datediff("d",cdate({WC4U999S.WS_DATE}),CurrentDate)=0
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Nov 2014 at 10:49am
	clarification how is the 'date' inside the WS_DATE field formatted? YYYY-MM-DD M/D/YY M/D/YYYY MM/DD/YYYY ?
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 14 Nov 2014 at 11:07am
	YYYY-MM-DD
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Nov 2014 at 11:24am
	datediff("d",cdate(right({WC4U999S.WS_DATE},5)+"-"+left({WC4U999S.WS_DATE},4)),CurrentDate)=0
	IP Logged

coountsr Newbie Joined: 23 May 2013 Online Status: Offline Posts: 20	Posted: 14 Nov 2014 at 11:42am
	its just reading records again
	IP Logged

<< Prev Page of 3 Next >>

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.