Hi All,
In standard table the date and time field are storing in same field like
31.05.2018 16:46:40.. In my requirement i wan to delete the latest records based on time and date..Before conversion routine the value is stored in lv_date1(diff format).
DELETE FROM TABLE WHERE created_by EQ sy-uname and created_at eq lv_date .
Because of conversion routine it is throwing sy-subrc = 4, this is not deleting any records..
Pleas give me suggestion to delete records based on time(greater than time).
Thanks.