topic Re: Requested Delivery Date Field in Application Development and Automation Discussions

Requested Delivery Date Field

Former Member — Thu, 20 Nov 2008 09:14:46 GMT

Hi Everyone,

I have a field in the database which stores the date in the following format 'WE 30.07.2008 02:00 CET'.

Which contains details like weekday, date, time and the time zone. My requirement is to retrieve the only the date from it. Do we have any function module for it?

Thanks,

Regards,

Chan

Re: Requested Delivery Date Field

Former Member — Thu, 20 Nov 2008 09:22:05 GMT

hi,

chanakya

It better to use sub strings instead of using FM.....coz it will be more performing......If the field always contains value in this 'WE 30.07.2008 02:00 CET'format then

delacre a variable and assign the dtae to it and use it fr further processing

i.e for example if int_dtae-date conatins 'WE 30.07.2008 02:00 CET and u want wf_loc_var to contain

'30.07.2008'

wf_loc_var = int_date-date=4(10).

get back if u face problem

Re: Requested Delivery Date Field

Former Member — Thu, 20 Nov 2008 09:34:21 GMT

Insted use SPLIT keyword to get date value.


  data : s1 type string,
           s2 type string,
           s3 type string,
           s4 type string ,
           s_main type string.

   split s_main at space into s1 s2 s3 s4.

then ur s2 will always contain DATE.

Regards

Sachin

Edited by: sachin sharma on Nov 20, 2008 10:36 AM