topic Re: date format.. in Application Development and Automation Discussions

date format..

Former Member — Thu, 18 Jan 2007 11:24:05 GMT

Hi,

i have a condition that that Dates will be converted into the format of YYYYMMDD, If user can give any format we can change it as YYYYMMDD.

i have function module CONVERT_DATE_TO_INTERN_FORMAT'.but it is converting the MMDDYYYY---YYYYMMDD.

But if the user give DDMMYYYY.How can we fullfill both condition..?

i.e MMDDYYYY & DDMMYYYY----YYYYMMDD.how can we proceed for this conditipn.

tHANKS

Re: date format..

Former Member — Thu, 18 Jan 2007 11:25:54 GMT

Hello.

Refere the date field to sy-datum

Regards,

Vasanth

Re: date format..

Former Member — Thu, 18 Jan 2007 11:32:00 GMT

Hi SKK ,

This is a bit tricky if the user gived data in both the format MMDDYYYY and DDMMYYYY , because if we get a date like 11122006 , how do we determine in which format has he given because in both the cases they are valid.

If it is only one format then we can surely find a solution to it.

Regards

Arun

Re: date format..

Former Member — Thu, 18 Jan 2007 11:34:47 GMT

Hi SKK,

use this FM

CONVERSION_EXIT_IDATE_INPUT

If user has option to give any of format ie,

mmddyyyy or ddmmyyyy and convert to yyyymmdd

it will be difficult for us to do.

suppose if user want to give march 05 2007

he has option to give 03052007 or 05032007.

by coding also we cannot know whether first two digits represents day or month

Re: date format..

Former Member — Thu, 18 Jan 2007 11:43:58 GMT

use formatting options... this is suggession

WRITE sy-datum DDMMYY

... DD/MM/YY | MM/DD/YY

| DD/MM/YYYY | MM/DD/YYYY

| DDMMYY | MMDDYY | YYMMDD

Re: date format..

Former Member — Thu, 18 Jan 2007 11:48:35 GMT

Hi ,

For example .

parameters : p_date like sy-datum.

Now you can give the date only in one format

this will be as per ur default settings in tcode SU3.

so either MMDDYYYY or DDMMYYYY jsut one of them is possible which is in equivalent with su3 settings .

The user cannot enter two formats at a single shot .

An error is triggered at the selection screen itself .

In case if he is trying to do the same then you need to convert it to Su3 defalut format and then to internal format as YYYYMMDD

regards,

vijay.

Re: date format..

Former Member — Thu, 18 Jan 2007 12:11:56 GMT

hI Vijay,

if one user fill the excel sheet with MMDDYYYY,another user give as YYYYMMDD,3rd user going to give as DDMMYYYY.then excel sheet will be convert all the date formats as YYYYMMDD.

How it possible.

Thanks.

Re: date format..

Former Member — Thu, 18 Jan 2007 12:38:22 GMT

hi sk,

You mean to say from sap r/3 if i download the same or is it the reverse you are saying . i didnt get you ?

is the upload or download i was not clear on the same .

//--then excel sheet will be convert all the date formats as YYYYMMDD.

No this is not possible in excel even only one format at a time is entertained for date format.

User cannot enter MMDDYYYY OR DDMMYYYY OR YYYYMMDD ALL AT A SINGLE INSTANCE.

regards,

vijay

at the time of download