topic Re: selection based on previous run date , time and current date a in Application Development and Automation Discussions

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

Former Member — Thu, 17 Dec 2009 13:08:50 GMT

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..

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

Former Member — Thu, 17 Dec 2009 13:20:32 GMT

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

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

agnihotro_sinha2 — Thu, 17 Dec 2009 13:26:57 GMT

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

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

Former Member — Thu, 17 Dec 2009 13:28:24 GMT

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

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

Former Member — Thu, 17 Dec 2009 14:03:34 GMT

hi all,

i need the sample code ..