2014 Jun 06 9:28 AM
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
2014 Jun 06 9:51 AM
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
2014 Jun 06 9:40 AM
Put condition
IF dat = '00000000'.
dat = ''.
WRITE : dat.
ENDIF.
2014 Jun 06 9:51 AM
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
2014 Jun 06 10:05 AM
HI mehwish
I do not have this in my Additional filed. can you tell me how did you get this .
2014 Jun 06 10:27 AM