topic Re: Sq02 in Application Development and Automation Discussions

Sq02

Former Member — Fri, 06 Jun 2014 08:28:08 GMT

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

Re: Sq02

Former Member — Fri, 06 Jun 2014 08:40:02 GMT

Put condition

IF dat = '00000000'.

dat = ''.

WRITE : dat.

ENDIF.

Re: Sq02

former_member188827 — Fri, 06 Jun 2014 08:51:33 GMT

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

Re: Sq02

Former Member — Fri, 06 Jun 2014 09:05:50 GMT

HI mehwish

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

Re: Sq02

Former Member — Fri, 06 Jun 2014 09:27:05 GMT

Thanks you It worked .