Date Time filter

[Anonymous]

Hi

I have a datetime field finish_time , which i converted to date fields as below, i want to get the data where the finish_time is between start_date and end_date, i have the calender bos set up for start_date and end_date in my report and user has to select two different dates from them , but when i select a date from start_date the same reflects in end_date , how do i over come this?

Basically i am trying to get the job data which are finished between selected dates by user , Please Help

TO_CHAR(FINISH_TIME,'MM/DD/YYYY')

AS

START_DATE,

TO_CHAR(FINISH_TIME,'MM/DD/YYYY')

AS

END_DATE,

[johnw]

There are several ways to do it. Here's the one I used:

Settings -> Document Properties -> Variables -> New

[#3]

Dear John when i copy your script in my qvw file and make two variable From and to

then again i copy your expression in my my chat it give me no value .

I attached my qvw file here with kindly check it.

Regards

Ashish Srivastava

[#4]

Please help me this issue.

Regards

Ashish Srivastava

[#5]

please please------------------------------

help me urgent basic.

Regards

Ashish

[Anonymous]

Ashish,

Create a new post and explain what you are trying to achive and what is the error your are getting in a new post ,

Then people might help you with what you want....

[johnw]

You copied only what you thought was the relevant portion of the script, and missed a very important piece. Your date format doesn't match the date format being read in. You're using 'M/D/YYYY', though not consistently. The dates are in 'D-M-YYYY'. Your date formats all need to be consistent. You can either fix your date formats to all match the inline load, or you can fix the inline load and your date formats to all be 'M/D/YYYY'. Either will fix your problem.

[wizardo]

hi, you can select a range of dates in a calendar style too, if you use the CTRL button while you select days you can select all the days of one month and then move to the next month and continue the selection (if you keep the CTRL button pressed)