topic Re: cdate convertion in Application Development and Automation Discussions

cdate convertion

Former Member — Wed, 28 Feb 2007 04:53:31 GMT

hi all

i have problem with the date formates my requirement is

– currently when running the upload program the document date (BKPF_BLDAT) defaults in to the current date. As the program is now, that date is being formatted in US MMDDYYYY. For those who use any other date format (i.e. European format DDMMYYYY) they are getting an error (Invalid date).

This is also a problem with the posting date field BKPF_BUDAT) which comes from the upload spreadsheet and will be in the same format as the user’s profile. We need to have this report changed so that both the date fields accept any and all date formats.

Re: cdate convertion

Former Member — Wed, 28 Feb 2007 05:01:31 GMT

Hi,

You can solve this type of problem with 2 statments.

Lets say your date is BKPF_BLDAT.

Data: Date1 type Sy-datum,
         date2(10) type c.
Move BKPF_BLDAT to Date1.
Write Date1 to Date2.

So, now here the Date2 will have the User format, it will pick the User date format.

Regards

Sudheer

Re: cdate convertion

Former Member — Wed, 28 Feb 2007 05:21:28 GMT

Hi,

Either you can use write to statement ie write (your date field) to (any char variable having 10 char as property).

Or you can check the login country from syst table and mask to get the required format of dates.

Regards,

Sunmit.