Date/Time Formula in Record Selection

[ToneV]

I am using Crystal 10 and am trying to write a formula in the record selection. I currently have a parameter, but am trying to do away with it for the report to run automatically in Enterprise without having to update the parameter everyday. I need to select the data from yesterday starting at 7am until the current day at 7am. I have the date figured out, but not sure how to incorporate the time. Here is my existing code:

date({Unit.ULCATIME}) in currentdate -1 to currentdate

Thanks!

 

[kskid]

I use the following in Crystal 8.5 but I don't see why it would not work for you. This assumes that your date field is a datetime value.

{Unit.ULCATIME} in [datetimevalue(currentdate - 1,timevalue(07,00,00)) to_ datetimevalue(currentdate,timevalue(07,00,00))]

Cheers,

-LW

 

[bdreed35]

Try this instead:

{Unit.ULCATIME} in dateadd("h",-17,currentdate) to dateadd("h",7,currentdate)


~Brian

 

[ToneV]

Thanks guys! They both seem to work.