topic Re: How to Compare DateTime Fields to Date Value Fields in Application Development and Automation Discussions

How to Compare DateTime Fields to Date Value Fields

former_member51918 — Mon, 01 Aug 2011 02:48:51 GMT

Hi Colleagues,

I have a Local table with Period as one the structure in it and it holds StartDate, EndDate with GDT APC_S_UP_LOCALNORM_DAT_TIM_PER

Now I need to compare the rows in the table based on a date field that I have of type APC_V_DATE. however it looks like it is not able to compare these two fields.

I am using the following expression:

period-start_date_time-content le low_date or period-start_date_time-content ge high_date

Can you please help.

Regards,

Rohit

Re: How to Compare DateTime Fields to Date Value Fields

Former Member — Mon, 01 Aug 2011 03:14:08 GMT

Hi Rohit,

Can you explain a bit more about your scenario? You want to compare records or fields means columns?

Regards,

Aabha

Re: How to Compare DateTime Fields to Date Value Fields

former_member51918 — Mon, 01 Aug 2011 03:29:41 GMT

GoodMorning Aabha,

I have an internal table (of 10 Columns) in which I have a Column Period. Period is of structure and Has Start Date and Endate.

Now I want to get records from this table comparing the date fields with another variable of type APC_V_DATE

Now I am facing problem in comparing it because of Different Data Types.

Re: How to Compare DateTime Fields to Date Value Fields

Former Member — Mon, 01 Aug 2011 03:44:03 GMT

Very Good morning Rohit,

Before comparing these fields convert them in same date formart. Then you can retreive the values by comparing both the dates.

Regards,

Aabha

Re: How to Compare DateTime Fields to Date Value Fields

former_member51918 — Mon, 01 Aug 2011 05:25:05 GMT

Correct, Now in order to convert my Date value to a Datetime Value I need to get some method from ISDT class...Which I can't see

Re: How to Compare DateTime Fields to Date Value Fields

Former Member — Tue, 02 Aug 2011 07:34:39 GMT

Hi,

There are many function Modules available which can convert Date Formats, Ex: CONVERSION_EXIT_SDATE_INPUT.

You can also search with convertdate* in tcode SE37, you will many FM, find the one suitable to you.

Regards,

Shweta Soragavi

Re: How to Compare DateTime Fields to Date Value Fields

Shahid — Tue, 02 Aug 2011 07:39:30 GMT

data: lv_date type "of your start date type".

write APC_V_DATE to lv_date.

Re: How to Compare DateTime Fields to Date Value Fields

former_member51918 — Fri, 19 Aug 2011 04:47:05 GMT

Thanks a lot colleagues for your help, I used the above suggestions from all and was able to achieve it.

Thanks.