Display all records within 24 hrs or a specified time

[DianaStewart]

I have a date and time field. I want to be able to display all the records where the date time field is before a specified time for example 3h00 am in the morning. It would be nice also if I could take the weekends into consideration as well. Example, if the day is monday then display all the records from last Friday only...

Help appreciated

 

[dgillz]

Create a parameter date time, and then put the following formula in your record selection:

If DayofWeek({?DateTime})=2 then {Datefield} in {?DateTime} to Dateadd("d",-3.{?DateTime}) else {Datefield} in {?DateTime} to Dateadd("d",-1.{?DateTime})


Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[DianaStewart]

If I open my report and todays date is Tuesday how can I display all the records from the previous day starting at 3h00 am in the morning. So in other words all the records entered in by Monday at 3h00 am in the morning will be displayed up to Tuesday...

 

[Naith]

If you already have a datetime parameter, then the time you specify will already take care of this for you. Without a datetime parameter, if you want to get all data from 3am on the last business day, then you'd amend the formula dgillz has already given you like:

If DayofWeek({?Date})=2 then {Datefield} in {?Date} to Dateadd("d",-3,DateTime(CDate({?Date}),CTime("03:00&quot)) else {Datefield} in {?DateTime} to Dateadd("d",-1,DateTime(CDate({?Date}),CTime("03:00&quot))

Naith