topic regarding script probleam in Application Development and Automation Discussions

regarding script probleam

Former Member — Wed, 19 Mar 2008 10:41:35 GMT

hi guru,

i am picking date field by writting in my form

&reguh-zaldt&.

here date coming from database ex.12-03-2007.

but my client wants this format 12-march-2007.

how to do this to convert 03 to march...

please help...

thanks

subhasis

Former Member — Wed, 19 Mar 2008 10:49:44 GMT

Please use any of this fm for computing dates:

DATE_COMPUTE_DAY – Finds day of the month

DATE_CONV_EXT_TO_INT - user formatted date is converted to system date

DATE_GET_WEEK - convert date into year + week format

DATE_TO_DAY – gives weekday from date

DATE_IN_FUTURE – takes number of days and date - gives future date in user format and system format

MONTH_PLUS_DETERMINE – add or subtract month from a date

RP_CALC_DATE_IN_INTERNAL – add/subtract year/month/days from a date

WEEK_GET_FIRST_DAY – take input as YYYYWW and it gives first day of the week.

MONTH_NAMES_GET – language is only parameter. Returns internal table with months.

MONTH_PLUS_DETERMINE – subtract months from date

Regards

Gopal

Former Member — Wed, 19 Mar 2008 10:52:52 GMT

Hi,

Use the following fn module, it will solve your problem.

CONVERSION_EXIT_IDATE_OUTPUT

In this, if you give 20070312 as import parameter, you will get 12MAR2007 as output.

Regards,

CS.

Note: Reward points if helpful.

Edited by: CSY on Mar 19, 2008 4:23 PM