date convertion

Former Member — Thu, 07 May 2009 22:19:58 GMT

hello to all ,

I need to convert some dates to internal format can some give me the name of the fm, I need to converte several date catergorys like

C 5 Calendar format Calndr

D 1 Day format Day

K 5 Calendar format Calndr

M 3 Month format Month

P 4 Period format Period

T 1 Day format Day

W 2 Week format Week

THANKS!!!

Re: date convertion

apoorva_singh — Thu, 07 May 2009 22:28:43 GMT

Hi david,

In ECC serach in SE37 using wild card CONVDATE and you will have modules depending on your requirement.

In CRM in SE37 same thing would do to help u out.

Regards

Apoorva

Re: date convertion

Former Member — Fri, 08 May 2009 00:59:09 GMT

Hi David,

Here I have some Date Calculating function modules... You can check & filter as per your requirement.


*To calculate week no for  particular date
    CALL FUNCTION 'DATE_GET_WEEK'
      EXPORTING
        DATE         = SY-DATUM " any date
      IMPORTING
        WEEK         = WEEK_NO ." Week no for particular date

*To calculate week Start & End date
        CALL FUNCTION 'HRWPC_BL_DATES_WEEK_INTERVAL'
          EXPORTING
            DATUM                = SY-DATUM " Current date (ITAB DATE)
            WEEK_PST             = '0'
            WEEK_FTR             = '0'
         IMPORTING
           BEGDA                = STR_WEEK_DATE  " Week start date
           ENDDA                = END_WEEK_DATE. " Week end date

*To calculate Months ending date
          CALL FUNCTION 'BKK_GET_MONTH_LASTDAY'
            EXPORTING
              I_DATE = SY-DATUM " Any date
            IMPORTING
              E_DATE = END_MONTH_DATE. " Month's ending date

*To calculate particular day No for any give date.
    CALL FUNCTION 'DATE_COMPUTE_DAY'
      EXPORTING
        DATE = SY-DATUM " any date
      IMPORTING
        DAY  = DAYNO1. " particular day no.

*To calculate particular day name with the day no
    CALL FUNCTION 'BKK_GET_DAY_OF_WEEK'
      EXPORTING
        I_DAY       = DAYNO " week day no.
      IMPORTING
        E_WDAY      = CURRENT_DAY_NAME. " Week day name for the week day no.

* To Calculate the next week
    CALL FUNCTION 'NEXT_WEEK'
      EXPORTING
        CURRENT_WEEK = WEEK_NO "Current week,
      IMPORTING
        NEXT_WEEK    = WEEK_NO. " Next week

* to calculating starting date of the week
    CALL FUNCTION 'WEEK_GET_FIRST_DAY'
      EXPORTING
        WEEK = WEEK_NO "week No
      IMPORTING
        DATE = STR_WEEK_DATE. " Starting date of the particular week

*To Calculate particular day No for any given date
        CALL FUNCTION 'DAY_IN_WEEK'
          EXPORTING
            DATUM = STR_WEEK_DATE " Any date
          IMPORTING
            WOTNR = DAY. " Day no for a giveN date

Thanks & regards,

Dileep .C

topic Re: date convertion in Application Development and Automation Discussions

date convertion

Re: date convertion

Re: date convertion