2008 Jul 24 2:02 PM
i have an o/p of 4 fields(name_first,name_last,partner,birthdt)
if we click on particular date(ex: 11.10.1960) of birthdt field in the o/p,it should be taken to another screen result consisting of the above 4 fields where birthdt = 11.10.1960.
AT LINE-SELECTION .
GET CURSOR FIELD F VALUE V.
IF F = 'LT_BUT000-BIRTHDT'.
split v at '.' into v1 v2 v3.
concatenate v1 v2 v3 into var.
date = var.
SELECT * FROM BUT000 INTO table LT_1BUT000
WHERE BIRTHDT = date.
but it is not working.
can any one suggest me.
2008 Jul 24 2:06 PM
Hi
Change the concatenate statement
concatenate v3 v2 v1 into var
and check it out...
regards
padma
Hi
Change the concatenate statement
concatenate v3 v2 v1 into var
and check it out...
regards
padma
2008 Jul 24 2:06 PM
Hi
Change the concatenate statement
concatenate v3 v2 v1 into var
and check it out...
regards
padma
2008 Jul 24 2:06 PM
2008 Jul 24 2:08 PM
2008 Jul 24 2:10 PM
Check the format of the date field ..
IF it is MM.DD.YYYY ..
then
split v at '.' into v1 v2 v3.
concatenate v3 v1 v2 into var.
condense var.
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |