topic Re: problem while displaying data for previous dates in Application Development and Automation Discussions

problem while displaying data for previous dates

Former Member — Tue, 16 Apr 2013 06:11:40 GMT

Hi All ,

Below is my selection criteria .

Type Of Object

DATE

TIME

My requirement is as below

When user enters date /time, it should download or display only those records which were created after that date. Say for e.g. after i have added parameter for date/time and I enter Object type BUS2007, date 28 Feb 2013 & time 07:10:23 and execute the program, it should show / download ZERO attachments. As existing attachment was created on 20,130,205,055,431 (2013 Feb 05 / 05:54:31 Hrs). But if I enter before date (30 Jan 2013 / 00:00:00), it should show 1 attachment.

how to get data for creation of current or previous dates ?

I have written below code i'm unable to get data for previous dates .

select INSTID_A

TYPEID_A

INSTID_B

from SRGBTBREL

into table t_SRGBTBREL

where TYPEID_A in S_TYPEID

and UTCTIME <= G_UTCTIME

and RELTYPE in (C_ATTA,C_NOTE,C_URL) .

Re: problem while displaying data for previous dates

Former Member — Tue, 16 Apr 2013 07:35:06 GMT

hi,

have u declared

data: G_UTCTIME type TZNTSTMPS.

if u take char15 it will not work.

Re: problem while displaying data for previous dates

former_member217544 — Tue, 16 Apr 2013 07:55:41 GMT

Hi,

Show your declaration part also.

Regards,

Swarna

Re: problem while displaying data for previous dates

Former Member — Tue, 16 Apr 2013 08:08:53 GMT

Hi smitha,

Use 'LE' instead of '<=' in your select query

Re: problem while displaying data for previous dates

Former Member — Tue, 16 Apr 2013 09:01:09 GMT

Coment time in your select statement because time can only be compared in 24hr time .

* and UTCTIME <= G_UTCTIME comment this line.

Regards,

Rahul Singh