Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 2011 Date Time with a parameter 2

Status
Not open for further replies.

jchewsmith

Technical User
Nov 20, 2006
161
US
I have created a date time parameter for a begin and end date. Is there a way to get time to default to begin of day and end of day so me filter will include all entries for July?

Start Date: = 7/1/15 00:00:00
End Date = 7/21/15 23:59:59
 
Just use Date parameters and then in your select say:
DATE({table.datetimefield}) in {?Begin Date} to {?End Date}
 
To be even more accurate and not need to mess with the time element, I'd use...
[tt]
Start Date: = 7/1/15
End Date = 7/21/15
[/tt]

and
[tt]
DATE({table.datetimefield}) >= {?Begin Date}
AND DATE({table.datetimefield}) < {?End Date} [highlight #FCE94F]+ 1[/highlight]
[/tt]




Skip,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top