topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Mon, 19 Mar 2007 10:40:11 GMT

i need to convert the date to start date

eg: if i get date from d.b table as 25.8.2005, then i need to transilate to 1.8.2005 by which f.m i can solve this issue.

Former Member — Mon, 19 Mar 2007 10:43:07 GMT

i think no fm is there do like this.

data : vdate like sy-datum.

concatenate dbdate(6) '01' into vdate.

now your vdate contains the data

regards

shiba dutta

Former Member — Mon, 19 Mar 2007 10:43:38 GMT

Hi,

Take the Month, Year from the Date by offsetting and use concatenation with

Year month '01' into a fresh date.

Or so many fun modules to get the first day of a month.

Regards,

Anji

Former Member — Mon, 19 Mar 2007 10:43:58 GMT

Instead, split the date into character variables and initialize day to '1' for the same month.

Former Member — Mon, 19 Mar 2007 10:46:30 GMT

data : v_date(10) value '25.08.2005',
          v_start(10).

concatenate '01' v_date+2(8) into v_start.

write : / v_start.

Message was edited by:

Chandrasekhar Jagarlamudi

Former Member — Mon, 19 Mar 2007 10:47:08 GMT

use the fm

HR_JP_MONTH_BEGIN_END_DATE

and pass ur date, u wil get both start date and end date of that month