cdate convertion

[Former Member]

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.

[Former Member]

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

[Former Member]

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.