searching for today with specific time to today+1 with specific time

[pharmIS]

I am brand new to crystal reports, and have to modify someone elses, we have converted to a new database and timedate is now one field.

I need to find records with todays date through tomorrows date with a specific time

example today @15:00 to tomorrow @1459 how do I do this,.

I am a pharmacist and not a programmer! thanks

 

[hilfy]

Will the time always be the same?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[pharmIS]

yes the search is from 15:00 to 14:59 from today to tomorrow (looking for future orders in a system)!

thanks

 

[hilfy]

You're going to create two formulas:

{@StartDate}
CurrentDate + TimeValue(15, 0, 0)

{@EndDate}
CurrentDate + 1 + TimeValue(14, 59, 59)

You will have to edit the selection formula in the Select Expert to be able to use these formulas in your record selection critera.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[pharmIS]

thanks! looks awesome! this board is great!