2007 Aug 30 8:57 AM
HALLOW
i use lb bill invioce and i have a problem with format of dates, whan i print the invoice ,some time the format is o.k. like date 30.8.2007 and sometimes the format of dates is 08/30/2007 (wrong) and i dont do anything just print diffrent bill
what can be the problem?
i reward kindly
Regards
2007 Aug 30 9:12 AM
Problem could be specific to user.
BASIS Job: In user maintenance - Defaults, there is setting for Date format.
-Alpesh
2007 Aug 30 9:12 AM
Problem could be specific to user.
BASIS Job: In user maintenance - Defaults, there is setting for Date format.
-Alpesh
2007 Aug 30 9:24 AM
Hi ,
Just put the syntax SET DATE MASK = 'DD.MM.YYYY' just before your data is printed. I hope you know where to put this syntax. No need to worry about user specific format.
Regards,
Nageswar
2007 Aug 30 9:32 AM
hi nageswara
i use sp standard lb_bill_invoice and i wont to cahnge that for all the format of dates (i have more then one date)in the invoice to be the same how i do that?
Best regards
2007 Aug 30 9:39 AM
The date format will change depending on the country to which your invoice is being sent and will be set automatically from table T005X. Check the country of the business partner on the form
So, if the business partner is in America (US) the date will be 08/30/2007, if they are in Britain (GB) it will be 30/08/2007.
This means it is formatted correctly for the person in the country who will be reading it, not the developer or the sender.
Regards,
Nick
2007 Aug 30 9:44 AM
hi nick
thankes for your answer !
i have to change the format to be same for all bills there is way to do that?
Regards
2007 Aug 30 9:50 AM
You could create some ABAP lines in your Smartform to MOVE your date field to a character field. If you then use this character field in your text element the country formatting will not be applied.
Regards,
Nick
2007 Aug 30 9:56 AM
hi nick
maybe u can give me example how to do that,i new in SF.
Regards
2007 Aug 30 10:07 AM
Ok, here goes.
Smartform section Global Definitions, tab Global data. Variable G_DATE TYPE CHAR10.
In the form, just before you want to display the date create a node 'Progam Lines'
In the 'Input parameter' section put the name of the field that contains your date (let's say it's called MY_DATE).
In the 'Output parameter' section put G_DATE.
In the editor put,
MOVE: MY_DATE(4) to G_DATE+6(4),
'/' to G_DATE+4(1),
MY_DATE+4(2) to G_DATE+3(2),
'/' to G_DATE+2(1),
MY_DATE+6(2) to G_DATE(2).
(replacing MY_DATE with the name of the date field in your form)
Now use field G_DATE in you text element instead of the original date field.
Enjoy.
Nick
2007 Aug 30 10:23 AM
thankes for your replais
i have solved it in tables t0005x i cahnge the country date format to 1
and its work?
tankes
i have anoter problem i open new tre maybe u can help
Regards
2007 Aug 30 10:05 AM
the best thing is check with basis consultant and make the date format unique. why unnessary coding and degarding performance will be taken for toss.
reward me for this valuable suggestion.
2007 Aug 30 10:09 AM
Hi Sandeep,
I'm interested in what you suggest (always wanting to avoid unnecessary code). How will the basis consultant be able to change the way this date appears?
Thanks,
Nick