Crystal Reports Show dates greater than Current date

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Show dates greater than Current date
	<< Prev Page of 2

Author

Message

rahulwalawalkar
Senior Member

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731

Posted: 15 Aug 2008 at 7:24am

Is it working now if not can you post sample data for

cp.pendingSettlementDate

cheers

Rahul

IP Logged

rahulwalawalkar
Senior Member

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731

Posted: 15 Aug 2008 at 7:25am

Can you post some sample data ,also let me know what else you have in record selection formula......

Cheers

Rahul

IP Logged

ashisahb
Groupie
Groupie

Joined: 15 May 2008
Location: India
Online Status: Offline
Posts: 48

Posted: 15 Aug 2008 at 7:28am

Here's is the sample data

08/18/2008

Regards,
Ashish

IP Logged

ashisahb
Groupie
Groupie

Joined: 15 May 2008
Location: India
Online Status: Offline
Posts: 48

Posted: 15 Aug 2008 at 7:30am

Regards,
Ashish

IP Logged

ashisahb
Groupie
Groupie

Joined: 15 May 2008
Location: India
Online Status: Offline
Posts: 48

Posted: 15 Aug 2008 at 7:38am

Hey

if i put the formula like this,

else if (totext({cp.pendingSettlementDate})>=("08/08/2008"))then
totext({cp.pendingSettlementDate})

it works fine...

Regards,
Ashish

IP Logged

ashisahb
Groupie
Groupie

Joined: 15 May 2008
Location: India
Online Status: Offline
Posts: 48

Posted: 15 Aug 2008 at 7:45am

say 08/18/2008 works fine.....but current date format is like

8/18/2008

so the 0 is missing ....can i change this is either my column or in current date format

Regards,
Ashish

IP Logged

ashisahb
Groupie
Groupie

Joined: 15 May 2008
Location: India
Online Status: Offline
Posts: 48

Posted: 15 Aug 2008 at 7:46am

can i trim the initial 0 from my date part????

Regards,
Ashish

IP Logged

ashisahb
Groupie
Groupie

Joined: 15 May 2008
Location: India
Online Status: Offline
Posts: 48

Posted: 17 Aug 2008 at 11:56pm

Guys ...

Its working now .I used Datevalue function to match the date part and constructed the following formula:

if (DateValue ({cp.pendingSettlementDate})>=DateValue (CurrentDateTime))
then totext({cp.pendingSettlementDate})

Regards,
Ashish

IP Logged

<< Prev Page of 2

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.016 seconds.