Crystal Reports Date/Time Suppression

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

Topic: Date/Time Suppression
	<< Prev Page of 2

Author	Message
south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 20 Sep 2012 at 4:44am
	It runs false on all, even the ones that have no date/time. Is there a way to find out what the default date is? I don't know if this helps but I have an SQL server and the date field that this table is getting information from is a drop down calandar. Thank you for you help!! I think I am going to give up!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Sep 2012 at 5:10am
	try table.datefield = date(1900,1,1) and see if you get any True values returned Edited by DBlank - 20 Sep 2012 at 5:11am
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 20 Sep 2012 at 8:15am
	All false
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Sep 2012 at 8:21am
	what number do you get on the 'blank' rows when you do this datediff('d',table.datefield,currentdate)
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 20 Sep 2012 at 8:32am
	you could also try totext({table.field}, "MM/dd/yyyy"}
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 20 Sep 2012 at 9:00am
	When I did the totext I got 12/31/-471
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Sep 2012 at 9:16am
	interesting i did not think negative year values were allowed... It wont accept date(-471,12,31) as a value so maybe try table.datefield < date(1900,1,1)
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 20 Sep 2012 at 9:29am
	It worked I was ready to give up a long time ago, and I would've if it wasn't for all your help!!! Thank you so much!!!!!!!!!!!
	IP Logged

<< Prev Page of 2

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.