Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Sq02

Former Member
0 Likes
854

Hi ,

I have coding in Additional field i have created in Sq02 .

Additinal field  PAid on ...

Type c

and coding is below

data: t_augdt like bsak-augdt,

if t_augbl =''.

Else.
   payment = t_augdt.
endif.

Now when I run report date come YYYYMMDD .

When I change the Field type from C to D i get the in DDMMYYYY format where there is no date I get 00.00.00000 which I do not want .

so my query is I want date in " Paid on " field  in format DDMMYYYYY or if its blank then Nothing .

All suggestions welcome .

Many Thanks

1 ACCEPTED SOLUTION
Read only

former_member188827
Active Contributor
0 Likes
795

In SQ01, go to basic list and on right window, you will see list fields, click on your field, and on left side bottom window, you will see field properties like length etc. There is also a check box "Only display field if <> 0". check the checkbox and see if it helps.

Regards

4 REPLIES 4
Read only

Former Member
0 Likes
795

Put condition

IF dat = '00000000'.

   dat = ''.

   WRITE : dat.

ENDIF.

Read only

former_member188827
Active Contributor
0 Likes
796

In SQ01, go to basic list and on right window, you will see list fields, click on your field, and on left side bottom window, you will see field properties like length etc. There is also a check box "Only display field if <> 0". check the checkbox and see if it helps.

Regards

Read only

0 Likes
795

HI mehwish

I do not have this in my Additional filed.  can you tell me how did you get this .

Read only

0 Likes
795

Thanks you It worked .