Dear Experts,
I have designed a report...where I want to show the posting date. But I am unable to set the spaces between the character.. like if date is 31 12 2017...I want to show 3 1 1 2 2 0 1 7
it always comes with 31 12 20 17
My code is below:
txtDate := COPYSTR(FORMAT("Gen. Journal Line"."Posting Date",8,1),1,2);
txtDate += COPYSTR(FORMAT("Gen. Journal Line"."Posting Date",8,1),4,2);
txtDate += FORMAT(DATE2DMY("Gen. Journal Line"."Posting Date",3),4,1);
intDtLen := 10;
REPEAT
txtDate := INSSTR(txtDate,' ',intDtLen);
intDtLen -= 1;
UNTIL intDtLen = 1;
*This post is locked for comments
I have the same question (0)
