Skip to Content
0
Former Member
Jul 19, 2008 at 08:54 PM

Wanna to see DATE as 00/00/0000 in LIPS, if there is NO REAL value for DATE

24 Views

Hi Experts,

I am creating DELIVERIES(entries in LIPS) from my Z prog.

In my Z prog. I defined the DATA TYPES for these fileds r,

data: Expiry_date(10),

Prod._date(10).

Expiry DATE and Production DATE fields of LIPS table, in some cases, would NOT have any value.

In this case, so, currently, these fields are NULLS or BLANKS.

But, I wanna to see them as 00/00/0000, if there is NO REAL value, so there shuld NOT b BLANKS?

1 - Shuld I chnage the DATA TYPES for these fileds?

2 - Shuld I explicitly MOVE 00/00/0000 this value to these fileds in my Z prog.?

request u that, How to get it done?

thanq

Edited by: Srinivas on Jul 19, 2008 4:56 PM

Edited by: Srinivas on Jul 19, 2008 5:01 PM

Edited by: Srinivas on Jul 19, 2008 5:05 PM