topic Re: Date format in Application Development and Automation Discussions

Date format

Former Member — Mon, 23 Jul 2007 13:24:14 GMT

Hi all,

I want to convert date which is in the format MMDDYY to sy-datum format YYYYMMDD.how can i do this?

Thanks,

Rakesh.

Re: Date format

RaymondGiuseppi — Mon, 23 Jul 2007 13:29:22 GMT

Try function module /SAPDMC/LSM_DATE_CONVERT.

Regards

Re: Date format

Former Member — Mon, 23 Jul 2007 13:30:14 GMT

Hi Rakesh.

Reply in your other thread.

Regards

Aneesh.

Re: Date format

Former Member — Mon, 23 Jul 2007 13:36:59 GMT

CONVERT_DATE_TO_EXTERNAL.

CONVERT_DATE_TO_INTERNAL.

DATE_STRING_CONVERT

Function Modules related to Date and Time Calculations

CALCULATE_DATE : Calculates the future date based on the input .

DATE_TO_DAY : Returns the Day for the entered date.

DATE_COMPUTE_DAY : Returns weekday for a date

DATE_GET_WEEK : Returns week for a date

DAY_ATTRIBUTES_GET : Returns attributes for a range of dates specified

MONTHS_BETWEEN_TWO_DATES : To get the number of months between the two dates.

END_OF_MONTH_DETERMINE_2 : Determines the End of a Month.

HR_HK_DIFF_BT_2_DATES : Find the difference between two dates in years, months and days.

FIMA_DAYS_AND_MONTHS_AND_YEARS : Find the difference between two dates in years, months and days.

MONTH_NAMES_GET : Get the names of the month

WEEK_GET_FIRST_DAY : Get the first day of the week

HRGPBS_HESA_DATE_FORMAT : Format the date in dd/mm/yyyy format

SD_CALC_DURATION_FROM_DATETIME : Find the difference between two date/time and report the difference in hours

L_MC_TIME_DIFFERENCE : Find the time difference between two date/time

HR_99S_INTERVAL_BETWEEN_DATES : Difference between two dates in days, weeks, months

LAST_DAY_OF_MONTHS : Returns the last day of the month

simple use:

WRITE date to ext_date MMDDYYYY.

date is in YYYYMMDD for mat type d

and ext_date(8) type c

data: l_date(10) type c.

write: sy-datum to date.

write : date.

regards,

srinivas

*rewards for useful answers*

Re: Date format

Vijay — Mon, 23 Jul 2007 15:24:43 GMT

just use the FM 'CONVERT_DATE_TO_INTERNAL'

it will solve your problem.

regards

vijay

reward points if helpful

Re: Date format

Former Member — Mon, 23 Jul 2007 15:29:17 GMT

Hi,

Use Function module HRGPBS_HESA_DATE_FORMAT

Regards

Sudheer

Re: Date format

Former Member — Mon, 23 Jul 2007 15:44:29 GMT

Hi,

Use function module

CONVERT_DATE_TO_EXTERNAL.

Pls reward all helpful points.

Regards,

Ameet