topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Fri, 26 Oct 2007 09:52:44 GMT

hello frnds,

my requirement is like this.

i want run a report. if i run the report on tuesday(15-03-07) the date should start from monday(14-03-07).

ho w can in achieve this functionality?

Re: date format

Former Member — Fri, 26 Oct 2007 09:54:17 GMT

jst use date = sy-datum - 1.

Re: date format

former_member189596 — Fri, 26 Oct 2007 09:56:06 GMT

Hi madam,

create select screen using sy-datum,

fetch data based on sy-daum - 1.

If useful, reward points,

Regards,

Bhaskar

Re: date format

Former Member — Fri, 26 Oct 2007 09:56:39 GMT

i dont know on wat day i may run.

let us say i run 2 day i.e., friday even though i should get starting date of the week i.e, monday

Re: date format

Former Member — Fri, 26 Oct 2007 10:00:30 GMT

I understand your requirement...

Just use this FM..this returns always that week monday...

CALL FUNCTION 'GET_WEEK_INFO_BASED_ON_DATE'

EXPORTING

date = sy-datum

IMPORTING

monday = pdat.

Re: date format

Former Member — Fri, 26 Oct 2007 10:02:59 GMT

Hi Madan,

chk this

REPORT YCHATEST2.

DATA : V_DATE LIKE SY-DATUM.

CALL FUNCTION 'GET_WEEK_INFO_BASED_ON_DATE'
 EXPORTING
   DATE          = SY-DATUM
 IMPORTING
*   WEEK          = WEEK
   MONDAY        = V_DATE.
*   SUNDAY        = SUNDAY.


WRITE : / 'First day of week is ' , V_DATE.

Re: date format

varma_narayana — Fri, 26 Oct 2007 10:03:17 GMT

Hi Madan..

These are the Hints:

First Call the FM DATE_GET_WEEK "Returns the Week No of the Given Date

Call the FM WEEK_GET_FIRST_DAY "Returns the First day of the week

reward if Helpful.

Re: date format

Former Member — Fri, 26 Oct 2007 10:05:36 GMT

You can use the FM - BWSO_DATE_GET_FIRST_WEEKDAY.

That will give the first day of the week.

Re: date format

Former Member — Fri, 26 Oct 2007 10:06:43 GMT

Hi Madan,

If you want the Start Date to be the 1st day of the week on which you run the report, then you can use the following FMs:

DATE_GET_WEEK: To get the week in which a date lies.

WEEK_GET_FIRST_DAY :To return first day for a particular week

Reward points for useful answers.

Re: date format

Former Member — Fri, 26 Oct 2007 10:07:04 GMT

Hi,

PARAMETERS: p_date TYPE sy-datum.

DATA: v_wotnr TYPE p.

INITIALIZATION.

p_date = sy-datum.

DO.

CALL FUNCTION 'DAY_IN_WEEK'

EXPORTING

datum = p_date

IMPORTING

wotnr = v_wotnr.

IF v_wotnr = 1.

EXIT.

ELSE.

p_date = p_date - 1.

ENDIF.

ENDDO.

Re: date format

Former Member — Fri, 26 Oct 2007 10:08:13 GMT

use the below FM: it will always give you the monday,

CALL FUNCTION 'GET_WEEK_INFO_BASED_ON_DATE'

EXPORTING

date = sy-datum

IMPORTING

monday = l_monday.

*reward if solved*

Re: date format

Former Member — Fri, 26 Oct 2007 10:13:13 GMT

how can i add 7 days to a date.

suppose v_date is type sy-datum

contains date as 22.10.2007.

how can i add 1 week to that date.

Re: date format

Former Member — Fri, 26 Oct 2007 10:15:38 GMT

Hi,

Please use the FM 'DATE_COMPUTE_DAY'.

With this FM you can get the day of the week using the current date.

for e.g. 0 stands for Monday,1 for Tuesday, 2 for Wednesday,3 for Thursday.

Once you get the day then you can subtract the exact no of days to get the get of Monday.

Hope it was useful.

Thanks,

Sandeep.

Re: date format

Former Member — Fri, 26 Oct 2007 10:17:05 GMT

Hi,

To add 7 days to your date

Use the function module

RP_CALC_DATE_IN_INTERVAL

Sample code:

DATA V_DATE TYPE SY-DATUM.

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

DATE = SY-DATUM

DAYS = 7

MONTHS = 0

SIGNUM = '+'

YEARS = 0

IMPORTING

CALC_DATE = V_DATE.

write:/ v_date.

Re: date format

Former Member — Fri, 26 Oct 2007 10:20:39 GMT

Hi Madan,

chk this

REPORT YCHATEST2.

DATA : V_DATE1 LIKE SY-DATUM,
       V_DATE2 LIKE SY-DATUM.

V_DATE1 = SY-DATUM + 7.

CALL FUNCTION 'GET_WEEK_INFO_BASED_ON_DATE'
 EXPORTING
   DATE          = V_DATE1
 IMPORTING
*   WEEK          = WEEK
   MONDAY        = V_DATE2.
*   SUNDAY        = SUNDAY.


WRITE : / 'First day of week is ' , V_DATE2.