Date Time Problems
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5874
Printed Date: 05 May 2024 at 6:42am
Topic: Date Time Problems
Posted By: crystalnoob
Subject: Date Time Problems
Date 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 |
Replies:
Posted By: DBlank
Date 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}
|
Posted By: crystalnoob
Date Posted: 24 Mar 2009 at 8:37am
|
That worked great! Thanks a lot!  |