Bex selection using DATE & TIME

[Former Member]

Hi

I would like to build selection on Bex query using both date & time characteristics to select records (time 24h format):

from ZDATE = '20110801' and ZTIME = '180000'

to ZDATE = '20110901' and ZTIME = '075959'.

Not using two queries, worksheets.

How to construct such variables?

Thanks a lot

Pawel.

[Former Member]

Hi,

You have to create two variables for zdate and ztime with interval.

But can you elaborate your question ....that you want the time and date has to come dynamically.

Regards,

Ranganath.

[Former Member]

Hi

e.g:

If I impute for DATE variable values '20110820' and '20110821'

and I impute for TIME variable values '180000' and '055959'

I don't want to select data from time between '180000' and '055959' for both days.

I would like to select data for one interval

from time '180000' of first day '20110820'

to time '055959' of second day '20110821'.

One time line.

THX

[ravikanth_indurthi]

Hi,

I think you can hardcode the time values using customer exit.

Hope this helps.......

Rgs,

Ravikanth.