Working of SELECT MIN when data field is blank

[Former Member]

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

[Former Member]

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

[Former Member]

hai,

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

[Former Member]

Hi,

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

Hope it helps.

Sujay