Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

select date which is latest

Hi ,

I am trying to pick a field from a database table based on the date...

I should select "the latest day in the past from today "...How do I write the select statement?

Tags:
Former Member
Former Member replied

Select all records into a table and then sort the table on date <descending>. Read this table with index 1. This will give you the latest record.

OR

Use order by clause on date field <descending>.

Hope it helps.

Lokesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question