topic Re: issue with date format save in custom database table in Application Development and Automation Discussions

issue with date format save in custom database table

Former Member — Thu, 08 Jun 2017 16:09:08 GMT

Hi ,

I want to save date in MM/DD/YYYY in custom database table field . its displaying as dd.mm.yyyy format. I know we can use char 10 and do necessary concatenation but i want any other good method for this.

Re: issue with date format save in custom database table

Sandra_Rossi — Thu, 08 Jun 2017 18:25:25 GMT

You should tell your client that it's a very bad idea from the modeling point of view, to not using the predefined date type (because it's then impossible to sort efficiently). Of course, they probably have a good reason to do that.

Re: issue with date format save in custom database table

Former Member — Thu, 08 Jun 2017 18:57:39 GMT

Go to System->User Profile -> Own Data -> Defaults -> Date Format (choose 2. MM/DD/YYYY).

Your default setting is the reason you are seeing the date in that way.

Raju.

Re: issue with date format save in custom database table

Former Member — Fri, 09 Jun 2017 12:53:35 GMT

Hi,

I know we can maintain that in SU3, I am looking for any other method.

Re: issue with date format save in custom database table

pokrakam — Fri, 09 Jun 2017 13:00:09 GMT

It's all in the documentation. Please look at the formatting options of string templates or the WRITE statement.

Re: issue with date format save in custom database table

douglas_linkup — Fri, 09 Jun 2017 13:06:17 GMT

"Date Format (choose 2. MM/DD/YYYY)"

It's a "other good method". No?

Re: issue with date format save in custom database table

former_member188080 — Fri, 09 Jun 2017 13:23:36 GMT

see if you can use any of customer exit for eg below one

split the date like below(I am giving just a psudo code) in the customer exit

example: MM/DD/YYYY - YYYYMMDD

A1 = SOURCE_FIELDS-calday+0(4) . ** YYYY

A2 = SOURCE_FIELDS-calday+0(2). **MM

A3= SOURCE_FIELDS-calday+2(2). ** DD

Concatenate A1 A2 A3 into your date field.

Re: issue with date format save in custom database table

ChrisSolomon — Fri, 09 Jun 2017 13:25:35 GMT

Same as Sandra Rossi......and wondering why you aren't just making this a "date" type field.....then use the "external-to-interal" conversion function to take "whatever" format the end user is using (based on their user profile setting as mentioned elsewhere in this thread) and then puts into the "internal" format SAP uses to actually store dates. Why try to complicate it? Unless as Sandra said, there are other "good" reasons for doing this.

Re: issue with date format save in custom database table

raghug — Fri, 09 Jun 2017 13:41:50 GMT

Another voice to this being a bad idea... maybe if you share the specific reason for trying to store a formatted date, we can give you better (or just other) ways of addressing your primary issue.

Re: issue with date format save in custom database table

retired_member — Fri, 09 Jun 2017 14:05:10 GMT

She says it's displaying ...

Maybe the storage format is even OK but not recognized as such. Simply not distinguishing internal format and external formats.

Re: issue with date format save in custom database table

rajkumarnarasimman — Fri, 09 Jun 2017 14:47:39 GMT

Hi Ramya,

Can you try EDIT MASK option in WRITE statement for DD/MM/YYYY format as shown below.

data: l_date TYPE char10.

write sy-datum to l_date USING EDIT MASK '__/__/_____'.
write sy-datum to l_date USING EDIT MASK '__.__._____'.
write sy-datum to l_date USING EDIT MASK '__-__-_____'.

Regards

Rajkumar Narasimman

Re: issue with date format save in custom database table

Former Member — Mon, 12 Jun 2017 07:42:32 GMT

Use a structure rather that substrings, or use the substring() function. The structure method is self documenting this in my view is a better way of coding it.

Types: Begin Of My_Date,
             Month Type My_Month,
             Fill1 Type c,
             Day   Type My_Day,
             Fill2 type c,
             Year  Type My_Year,
       End Of My_Date,
       Begin Of Sap_Date,
             Year  Type My_Year,
             Month Type My_Month,
             Day   Type My_Day,
       End Of Sap_Date.
Data: l_Date     Type my_Date,
      l_Sap_Date type sap_Date.
l_Date = 'MM/DD/YYYY'.
Move-Corresponding l_Date to l_Sap_Date.

And then just move l_Sap_Date to a real date field. To go the other way, populate the SAP date and move to the l_Date, populating the fill fields.

Rich