Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Requested Delivery Date Field

Former Member

‎11-20-2008 9:14 AM

0 Kudos

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

2 REPLIES 2

Former Member

‎11-20-2008 9:22 AM

0 Kudos

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

Former Member

‎11-20-2008 9:34 AM

0 Kudos

Hi

Insted use SPLIT keyword to get date value.

like 


  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