topic Re: regarding date selction from a range in Application Development and Automation Discussions

regarding date selction from a range

Former Member — Wed, 25 Apr 2007 07:09:50 GMT

i have two fields of table

bedga that is the starting date

endda thats the end date

now suppose begda have the value 01.02.2002

and endda have the value 31.12.9999

now what i have to do i have to write a select query that retrives data from the two dates thats the satrting date as well as the end date

now depending on the data entered by the user the query should pick the record.

suppose user enter starting date as 01.04.2007 and end date as 31.01.2007 then it should look in between the two fielda of the table and pick the record

what i am doing is i am making it as stsrtdate > userenter start date

and end date < user entered end date but it is not picking any records.

please let me know if some thing can ce done

i need record of a financila year from the satrting date and the end date that is ying between the values of these fields

Re: regarding date selction from a range

Former Member — Wed, 25 Apr 2007 07:12:28 GMT

HI,

In ther where clause you can write the code. ..

WHERE DATE BETWEEN START_DATE AND END_DATE.

Regards

Sudheer

Re: regarding date selction from a range

aabhas_wilmar — Wed, 25 Apr 2007 07:13:20 GMT

select * from <table> into <itab> where begda >= user_entered_begda and enda is <= user_entered_endda.

regards,

Aabhas

Re: regarding date selction from a range

Former Member — Wed, 25 Apr 2007 07:18:47 GMT

are u using select options ??if so try this

chk this

select .. where startdate GT s_date-low and enddate LT s_date-high.

Re: regarding date selction from a range

Former Member — Wed, 25 Apr 2007 09:28:15 GMT

try this

select ...... where startdate in s_date and enddate in s_date.

I think this will solve your problem.

Reward if useful

Regards,

Sudheer

Re: regarding date selction from a range

Former Member — Wed, 25 Apr 2007 09:32:13 GMT

Hi Ashish,

write...

SEELCT <FIELDS> FROM DBTABLE WHERE BEGDA <= STARTDATE AND ENDDA >= ENDDATE.

This will definitely work,

Reward points for helpful answers,

Regards,

Tejas

Re: regarding date selction from a range

dani_mn — Wed, 25 Apr 2007 09:37:12 GMT

HI,

you are using the reverse logic

DO LIKE THIS

stsrtdate <= userenter start date

and end date >= user entered end date

Regards,

Re: regarding date selction from a range

Former Member — Mon, 07 May 2007 10:50:34 GMT

Hi,

U have to award points for useful answers and u have to mention it as solved if ur question is solved. Dont forget.

Regards,

Sudheer