topic Re: date time issue in Application Development and Automation Discussions

date time issue

Former Member — Thu, 09 Aug 2007 16:13:15 GMT

I am trying to extract data from CRMD_ORDERADM_H table (SRM) using the date contract was changed. On the selection screen I have contract change date. But the CHANGED_AT field is combination of date and time in the table. How should I extract the data. When I pass only date it gives me error 'pass time also'.

Please advice.

Thanks.

Re: date time issue

Former Member — Thu, 09 Aug 2007 16:28:36 GMT

Make it a range with one date, but the time from 00:00:00 to 23:59:59.

Rob

Re: date time issue

Former Member — Thu, 09 Aug 2007 16:33:21 GMT

Rob-

I have a range (select option) for the date on the selection screen. Is there a function module to take care of this.

Thanks,

Re: date time issue

Former Member — Thu, 09 Aug 2007 16:47:21 GMT

Can't you just use BETWEEN?

Rob

Re: date time issue

Former Member — Thu, 09 Aug 2007 17:21:56 GMT

hello friends,

I have a field in a table which is of data type dec 15 with a conversion exit TSTLC on the domain. So the values inserted will be converted into timestamp.

Now my problem is to select records from the table on the basis of this feild less then or greater then value inserted by user.

how can i do this? in the program.

Please help.

Re: date time issue

ferry_lianto — Thu, 09 Aug 2007 17:31:41 GMT

Hi,

You can use FM IB_CONVERT_INTO_TIMESTAMP to convert date and time to timestamp.

Also use FM IB_CONVERT_FROM_TIMESTAMP to convert timestamp to date and time.

Regards,

Ferry Lianto

Re: date time issue

Former Member — Thu, 09 Aug 2007 17:35:25 GMT

Those function modules are not available in SRM.

I am trying to extract data from CRMD_ORDERADM_H table (SRM) using the date the contract was changed. On the selection screen I have contract change date. But the CHANGED_AT field is combination of date and time in the table. How should I extract the data. When I pass only date it gives me error 'pass time also'.

Please advice.

Thanks.

Re: date time issue

ferry_lianto — Thu, 09 Aug 2007 18:03:51 GMT

Hi,

Please try this.


RANGES: R_TSTAMPS FOR TZONREF-TSTAMPS.
                                                                        
DATA: WA_TSTAMPS1 TYPE TZONREF-TSTAMPS,
      WA_TSTAMPS2 TYPE TZONREF-TSTAMPS.
                                                                        
CONSTANTS: C_TIME1 TYPE SY-TIMLO VALUE '000000',
           C_TIME2 TYPE SY-TIMLO VALUE '235959'.
                                                                        
CONVERT DATE P_DATE TIME C_TIME1
INTO TIME STAMP WA_TSTAMPS1 TIME ZONE SY-ZONLO.
                                                                        
CONVERT DATE P_DATE TIME C_TIME2
INTO TIME STAMP WA_TSTAMPS2 TIME ZONE SY-ZONLO.
                                                                        
R_TSTAMPS-SIGN   = 'I'.
R_TSTAMPS-OPTION = 'BT'.
R_TSTAMPS-LOW    = WA_TSTAMPS1.
R_TSTAMPS-HIGH   = WA_TSTAMPS2.
APPEND R_TSTAMPS.

Next, you can use the above range to select/extract the data from table.

Regards,

Ferry Lianto

Re: date time issue

Former Member — Fri, 10 Aug 2007 12:59:04 GMT

Thank you. It resolved the issue.