Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: RecordSelectionFormula for 24 hrs. data Post Reply Post New Topic
Author Message
umesh.chape
Newbie
Newbie


Joined: 12 May 2011
Online Status: Offline
Posts: 11
Quote umesh.chape Replybullet Topic: RecordSelectionFormula for 24 hrs. data
    Posted: 07 Jun 2011 at 11:18pm
Hi All,

I Generated report to show data of last 24 hours .

I am using below RecordSelectionFormula ,

rpt.RecordSelectionFormula = "cdate({tbDoc.ArrivalDate})=CDate('" + 2011-06-07 + "') and CTime({tbDoc.ArrivalTime})>= CTime('" + 9:00 PM+ "')   or cdate({tbDoc.ArrivalDate})=CDate('" + 2011-06-08 + "') and CTime({tbDocumentDetails.ArrivalTime})>= CTime('" + 9:00 PM+ "')"

But it reocrd time is 12:00 Am for date 2011-06-08 then it is not showing the reocrd..

Please help me .

Edited by umesh.chape - 07 Jun 2011 at 11:33pm
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 07 Jun 2011 at 11:59pm
you could try cdatetime(ArrivalDate & ' ' & ArrivalTime) >= dateadd ("h",-24,currentdatetime)
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
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.017 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.