Query regarding Date

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Manoj,

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

Thanks,

Deep.

[Former Member]

Yes. you can.

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

[anversha_s]

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

[Former Member]

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.