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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

parameter date/time problems 1

Status
Not open for further replies.

pharbilj

Technical User
Sep 1, 2010
3
GB
I am trying to report on all issues of an item from a specific date and time, unfortunately the date and time are stored separately.
I have been using the following formular
issue_table.issue_date =>{?date_sent}
issue_table.issue_time =>{?time_sent}

If i enter in the input parameters
date_sent 27/08/2010
time_sent 14:00:00
i only get issues from 14:00:00 for each day.
How do i get all issues from 14:00:00 on 27/08/2010 todate.
 
Try:

(issue_table.issue_date ={?date_sent}
and issue_table.issue_time >={?time_sent})

or

(issue_table.issue_date > {?date_sent})

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top