selection based on previous run date , time and current date a

[Former Member]

HI all,

I have the selection as follows.

Previous run date : .12/14/2005.. previous run time-14:30:56

current run date : 12/17/2009. current run time: 07:05:31

Here all are parameters. and current run date is system date and current run time is system time.

i want to fetch all the deliveries from the above selection including previous run date and time.

Any inputs..

[Former Member]

HI all,

I have the selection as follows.

Previous run date : .12/14/2005.. previous run time-14:30:56

current run date : 12/17/2009. current run time: 07:05:31

Here all are parameters. and current run date is system date and current run time is system time.

i want to fetch all the deliveries from the above selection including previous run date and time.

Any inputs..

[Former Member]

Hi

Append current run data and previous run data into a data range parameter,Current time and previous time into time range parameter and fetch the data based on the range parameters.

Regards

Srilaxmi

[agnihotro_sinha2]

Use SELECT statement with BETWEEN operator for fetching deliveries from Database Tables.

[Former Member]

Hi,.

As suggested by lakshmi it wouldbe better to create a selection option by appending the dates and times.

Then you can use the option field i,e range data in your queries.

thanks,

M.Naveen Kumar

[Former Member]

hi all,

i need the sample code ..