topic Re: Query regarding Date in Application Development and Automation Discussions

Query regarding Date

Former Member — Wed, 14 Feb 2007 05:00:08 GMT

Hi All,

I have a issue regarding date.

I have 3 fields in my D.B.Table

<b>Field1, Field2 and DATE</b> Fields.

Now with select query i want to retrieve Field1 & Field2 For Latest Date in DATE field!

Can anybody give solution!

Thanks in advance.

Thanks,

Deep.

Re: Query regarding Date

Former Member — Wed, 14 Feb 2007 05:05:29 GMT

Use this code.

select single fld1 fld2 from <table>
         into (v_fld1, v_fld2)
         where date eq ( select max( date ) from <table> ).

or 

select single fld1 fld2 from <table>
         into table gt_fields
         where date eq ( select max( date ) from <table> ).

Re: Query regarding Date

anversha_s — Wed, 14 Feb 2007 05:07:37 GMT

hi,

1 . fetch all the records into an itab.

2. sort that itab by date

3. so the latest record will come in top.

4. take Field1, Field2 from that.

Regards

anver

Re: Query regarding Date

Former Member — Wed, 14 Feb 2007 05:18:33 GMT

Hi Manoj,

I can use another condition NAME EQ '' in where condition right!

Thanks,

Deep.

Re: Query regarding Date

Former Member — Wed, 14 Feb 2007 05:20:08 GMT

Yes. you can.

select fld1 fld2
....
where date eq ( select max( date ) ... ) 
and    name eq p_name.

Re: Query regarding Date

Former Member — Wed, 14 Feb 2007 05:20:25 GMT

Select date field1 field2
           from xxxx
           into table itab.

if sy-subrc = 0.
 sort itab descending by date.
 Read itab with key index 1.
endif.