Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Date Time Problems Post Reply Post New Topic
Author Message
crystalnoob
Newbie
Newbie


Joined: 24 Mar 2009
Online Status: Offline
Posts: 2
Quote crystalnoob Replybullet Topic: Date Time Problems
    Posted: 24 Mar 2009 at 8:07am
Hello all.

I have a report that I would like to have automatically emailed to reps daily.  It is a Daily Shipping Log that logs order information and tracking numbers.  Only problem is our warehouse system saves shipping date as a date time field, example-> 3/24/2009 11:23:56AM and the time changes every time a box is scanned to be shipped. 

Currently I manually select the date shipped in the Select Expert in a from to fashion-> From 3/24/2009 12:00:00AM to 3/24/2009 11:59:59PM

Is there a way I can somehow get a parameter set up to do this for me?

Any help is much appreciated!

Brian
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Mar 2009 at 8:22am
So you want to every record where the date portion of the datetime field is = today?
date({table.datetimefield})=currentdate
 
If you want to do this for a selected date at runtime add a parameter as a date field and change the selection criteria to:
date({table.datetimefield})={?parameter}


Edited by DBlank - 24 Mar 2009 at 8:25am
IP IP Logged
crystalnoob
Newbie
Newbie


Joined: 24 Mar 2009
Online Status: Offline
Posts: 2
Quote crystalnoob Replybullet Posted: 24 Mar 2009 at 8:37am
That worked great!

Thanks a lot!Big%20smile
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.031 seconds.