Skip to Content
avatar image
Former Member

Working of SELECT MIN when data field is blank

Hi expert,

I'd like use the SELECT MIN instruction to take the older data (yyyy/mm/dd).

If by accident I have a Data value = blank, the SELECT MIN does will take it?

I should be sure that the SELECT MIN does not take an initial value.

Thanks for your support.

Claudia

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 21, 2010 at 11:24 AM

    Hello Claudia,

    As per my understanding, If a date field has an initial value then by default it will have a value '00/00/0000'. In order to avoid the initial values you can put in where clause 'field is not initial'

    Hope this helps.

    Regards,

    Himanshu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 11:54 AM

    hai,

    try adding a condition like where <field> NE NULL.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 12:08 PM

    Hi,

    When you select min( date ), SAP picks the minimum value of the values passed. It ignores which are initial.

    Hope it helps.

    Sujay

    Add comment
    10|10000 characters needed characters exceeded